cube locks up....
Posted on 2008-10-16
I am trying to create a static report using Visual Studio 2005 Report Server Project. My datasource is an Analysis Services cube.
I wanted to create some Calulated Member fields to use at the reporting level, but when I drag in the 6 Dimensions I need, with the 4 or 5 Calculated Members, the cube just hangs. I let it query for a few hours before killing the process.
These are simple calculations, ie, Col1 + Col2 + Col3, or "CASE WHEN product = 'GAS' THEN 0 ELSE value END.
When I take out the calculated members and drag in the cube's measures, its super fast, maybe 1 second to display the report.
Is is not recommended to use Calculated Member fields with a report built on Analysis Services? Has anyone successfully put in a Calculated Member field in a report with an Analysis Services datasource?