Hello,

Drillthru is Enabled in the cubes, works fine some times gives this
serious error message.

"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 by one of the experts 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.