March 10, 2010 at 8:07 am
Dear Folks,
I have situation where I need to populate a parameter dropdown in a report based on the parameter selected above it but each time the values will be from different cube.
Example:
ChartType: BySales or ByExpenses ( Tells the type of report)
Date: Date(s) ( a Multi-select dropdown)
Vendor: Vendor ( list of vendors based on charttype for the selected date)
This vendor dropdown gets data from two different Cubes, which are present in same SSAS database.
Current MDX is working fine for single date value. It uses LookUpCube()
WITH
MEMBER [Measures].[VendorID] AS
[Vendor].[Vendor].CURRENTMEMBER.UNIQUENAME
MEMBER [Measures].[RelevantVALUE] AS
LookUpCube(Iif(@ChartType = "1"
,"[BySales]"
,"[ByExpenses]")
,"([Measures].[Value], " +
[Vendor].[Vendor].CurrentMember.UniqueName + ", " +
StrToMember(@date,constrained).UniqueName +" " +
+ ")")
SELECT {[Measures].[VendorCaption]
,[Measures].[VendorID]} ON COLUMNS
,Filter(
NonEmpty(
descendants([Vendor].[Vendor].[ALL],,after)
,[Measures].[RelevantVALUE])
,[Measures].[RelevantVALUE] <> 0) ON ROWS
FROM [BySales]
I need to implement the same with multivalues of Date.
Do you have any fix for this MDX, or any other suggestion--something to do with seperate datasets/internal parameters/referencing parameters or any combination of these items.
Thanks
Sumit
March 10, 2010 at 1:06 pm
have you tried this and gotten an error? i tried something like this a few weeks ago and it wouldn't let me use parameters like that. Forgot the name MS used. i had to do selects from tables to get my parameters
March 10, 2010 at 5:51 pm
ABove query works absolutely fine with StrToMember() for date parameter
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply