dbTalk Databases Forums  

BUG drillthrough.htc

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss BUG drillthrough.htc in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Reinfried
 
Posts: n/a

Default BUG drillthrough.htc - 12-13-2004 , 11:05 AM






I have a measure 'quantity', defined as decimal,precision = 13, numericscale
= 6 in the facttable.
This measure is activated in the drillthrough-options in the cube.
When I make a drillthrough with drillthrough.htc and in the filteraxis a
dimension has multiselect, then the result is empty - no details are shown.

Without multiselect all details are shown.

I have hardcoded now in the drillthrough.htc in the 'function
BuildMasterRecordset()'
after:

rsMaster.Fields.Append(sName, rsTemp.Fields(i).Type,
rsTemp.Fields(i).DefinedSize, rsTemp.Fields(i).Attributes);

following code:

if (rsMaster.Fields(i).Name == "quantity")
{
rsMaster.Fields(i).Precision=13;
rsMaster.Fields(i).NumericScale=6;
}

and now also with multiselect all details are shown.

But hardcoding a measure in the htc-File I find this not very fine.

Is there a better solution?

Many Thanks.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.