Hi,

i am getting an error "Could not get detail records for this aggregate.
Make sure that permissions to obtain drillthrough records are set
properly on the OLAP server"

Solution proposed for this was to change the code

from
=============================
sMDX = "DRILLTHROUGH\n";
sMDX = sMDX + "SELECT FROM [" + element.DataMember + "]\n";
sMDX = sMDX + "WHERE (" + GetTupleMDX(tupCore);
=============================

to
=============================
sMDX = "DRILLTHROUGH\n";
if (element.DataMember.charAt(0) == "[")
sMDX = sMDX + "SELECT FROM " + element.DataMember + "\n";
else
sMDX = sMDX + "SELECT FROM [" + element.DataMember + "]\n";
sMDX = sMDX + "WHERE (" + GetTupleMDX(tupCore);
=============================

but the error still persisits.

Can anyone let me know resolution for the same.

Thanks in advance.

Regards
Pras

Urgent! Calling all experts to suggest on the issue raised

prasannat (AT) gmail (DOT) com wrote: