September 25, 2014 at 10:48 pm
iam creating an ssrs report which i created using MDx
i wrote below query in that [parent cose head] and [Cost Center] dimension don't have any relation
but i have to get those two dimension values in rows
is there any possibilty to get this.....please help me......
SELECT NON EMPTY { [Measures].[Amount - Revenue], [Measures].[Amount] } ON COLUMNS,
NON EMPTY { ([Cost Center].[Cost Center Name].[Cost Center Name].ALLMEMBERS *
[Date].[Financial Quarter].[Financial Quarter].ALLMEMBERS*
[Parent Cost Head].[Cost Head Name].[Cost Head Name].ALLMEMBERS) } ON ROWS FROM
(SELECT STRTOSET(@CostCenter, CONSTRAINED) ON 0 FROM
(SELECT STRTOSET(@Account_Name, CONSTRAINED) ON 0 FROM
(SELECT STRTOSET(@FinancialYear, CONSTRAINED)
ON 0 FROM [ichange])))
September 26, 2014 at 4:27 am
what is issue with your query ?
September 26, 2014 at 5:51 am
Is it possible to give some sample data and the desired output?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply