Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SSAS Cub response SLOW
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] SSAS Cub response SLOW
 Login/Join
 
Member
posted
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
 
Posts: 25 | Location: Nashville Tn | Registered: January 12, 2010Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 22 | Registered: July 01, 2014Reply With QuoteReport This Post
Member
posted Hide Post
ALso please post the output of the following command: ENGINE SSAS ?

Thanks


WebFOCUS 7.6
Windows, All Outputs
 
Posts: 22 | Registered: July 01, 2014Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] SSAS Cub response SLOW

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.