Focal Point
[CLOSED] SSAS Cub response SLOW

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8247063276

August 25, 2014, 03:12 PM
MG
[CLOSED] SSAS Cub response SLOW
Good afternoon all,
I have a SSAS cube that I am reporting from. 4 Dim tables 1 fac table. I have a fex that produces a report for 'Current Period' but not for 'year to date' These are values for a filed call Period to date calc. Here is a simplified version of the code, the original is way to long and parameterised to put here.

TABLE FILE REV
PRINT
OPERATION
Year
Month
Balance
Scenario_Name
Account_Type
Account_Description11
GROUP_ID1
REGION_ID11
OPERATION_ID1
LOCATION
REGION_ID11
OPERATION_ID1
LOCATION
Display_Date11
WHERE Scenario_Name11 EQ 'ACTUALS' OR 'BUDGET' OR 'LAST YEAR';
WHERE Account_Type EQ 'STATISTICAL' OR 'TRANSIENT';
WHERE Period_To_Date_Calc11 EQ 'Year to Date';
WHERE Month EQ '5';
WHERE Year EQ '2014';
WHERE MARKET21 EQ '_FOC_NULL';
WHERE LOC_TYPE1 EQ '_FOC_NULL';
WHERE SAMESTORE11 EQ '_FOC_NULL';
WHERE CONSOLIDATING EQ 'Y'
WHERE GROUP_ID11 EQ 'S3';
END

This produces a hold file that I report from. or it does for one of the two values.

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8.05
Windows , Excel, PDf, HTML
August 26, 2014, 09:01 AM
HarryLo
I noticed that in some cases, you are filtering on one iteration of a column (e.g. Scenario_Name11) and displaying a different column (e.g. Scenario_Name). Have you tried filtering and displaying using the same column? Are you the actual cube or a local "cub" (local) file?


WebFOCUS 7.6
Windows, All Outputs
August 26, 2014, 09:29 AM
HarryLo
ALso please post the output of the following command: ENGINE SSAS ?

Thanks


WebFOCUS 7.6
Windows, All Outputs