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

http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8247063276

August 25, 2014, 03:12 PM

[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

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.

WebFOCUS 8.05

Windows , Excel, PDf, HTML

August 26, 2014, 09:01 AM

WebFOCUS 7.6

Windows, All Outputs

August 26, 2014, 09:29 AM

Thanks

WebFOCUS 7.6

Windows, All Outputs