I am migrating cognos power play reports into ssrs.Already i migrated cognos cube in to ssas cube.Now the problem is in cognos report , it is having attribute from different dimensions in single column.how to achieve this in mdx query or ssrs.
Please let me know whether it is possible in SSAS or SSRS.
I want result like below
Thanks and Regards,
We can't define the same name for the attributes in the dimension. If an attribute that uses that name already exists, Analysis Services adds an ordinal number suffix, starting with "1" for the first duplicate name. For more information, please refer to the articles below:
Define a New Attribute Automatically: http://technet.microsoft.com/en-us/library/ms174523.aspx
Define a New Attribute Manually: http://technet.microsoft.com/en-us/library/ms174795.aspx
Bind an Attribute to a Name Column: http://technet.microsoft.com/en-us/library/ms174836.aspx
Modify the KeyColumn Property of an Attribute: http://technet.microsoft.com/en-us/library/ms175461.aspx
TechNet Community Support
Thanks for your reply. But that articles are not related to my question. What I need is
I am having two dimensions.
I need an mdx query to return result like below. Basically need to have set with different dimensions