R
Reinfried
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.
= 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.