Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Analysis Server and Reporting Services (2012)
 Get dimension member from parameter

Author  Topic 

waterduck
Aged Yak Warrior

982 Posts

Posted - 2013-10-01 : 03:47:30
SELECT
MEASURES ON 0
, {StrToMember("[Product].[Product].&[" + "223" + "]")} * [Product].[Model Name] ON 1
FROM
[Adventure Works]


How do i get the actual model name? above query is returning

wrong output
Reseller Sales Amount
-------------------------------------------------------
AWC Logo Cap All Products $5,081.05



should be
Reseller Sales Amount
-------------------------------------------------------
AWC Logo Cap Cycling Cap $5,081.05



   

- Advertisement -