I have created 2 datasets. my first dataset quary parameter is BU. query is like following.
WITH
MEMBER [Measures].[Amount] AS 'IIF(ISEMPTY([Measures].[Amount Usd]),0,[Measures].[Amount Usd])'
MEMBER [Measures].[Description] AS '[Ledger—AccountCode].CurrentMember.Name'
SET [FilteredBUList] AS strtoset(@.BU)
SELECT
{[Measures].[Description],[Measures].[Amount]} ON COLUMNS,
[FilteredBUList] on rows
FROM Profitability
my second dataset query is like following,
SET [FilteredBUList] AS strtoset(@.BU)
SET [customtimeset] AS.....
SELECT
{[Measures].[Description],[Measures].[Amount]} ON COLUMNS,
intersect( [FilteredBUList],...) on rows
FROM Profitability
i need to map previous query BU parameter to the second dataset parameter. pls tel m the proper way.
cant access report parameter in this way from different dataset.
WITH
MEMBER [Measures].[Amount] AS 'IIF(ISEMPTY([Measures].[Amount Usd]),0,[Measures].[Amount Usd])'
MEMBER [Measures].[Description] AS '[Ledger—AccountCode].CurrentMember.Name'
SET [FilteredBUList] AS strtotuple(@.BU)
SELECT
{[Measures].[Description],[Measures].[Amount]} ON COLUMNS,
[FilteredBUList] on rows
FROM Profitability
No comments:
Post a Comment