Below query output results time taking very much.
SELECT NON EMPTY
{[Measures].[Score]} ON COLUMNS,
NON EMPTY {
(DESCENDANTS({[Organisation].[Organisation].&[36]},0),
[Question].[Type Id].[Category Id],
[Question].[Type Description].[Category Description],
[Question].[Short Description].[Short Description]
)}
HAVING [Measures].[Points]>0 ON ROWS
FROM (SELECT [Assignment].[Id].&[1] ON COLUMNS
FROM [Sample])
Total 7 dimensions 2 measure groups
Fact Table : 18,000,00 Records
Dimensions: 2000 Records
[Organisation].[Organisation] having 9 levels
like
Level1
Level2
LEVEl3
Is there any solution to improve the query performence.Any steps to inreasing performence of cube. Please help me. this is urgent for me
Could you please rewrite your query in terms of AdventureWorks?
No comments:
Post a Comment