Get dimension member from parameter

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources