-
report parameter
WITH
SET [FilteredBUSet] AS '"+Parameters!BU.Value+"'
SET [FilteredAccountSet] AS '[Account—BUSegmentBCDsc].[Billing Code Description].members'
SET [CustomTimeSet] AS 'Descendants([Date—Fiscal].[All Date—Fiscal].[2005].[Quarter 1]:
[Date—Fiscal].[All Date—Fiscal].[2006].[Quarter 2],[Date—Fiscal].[month],Leaves)'
SELECT
nonempty (CROSSJOIN([CustomTimeSet],INTERSECT([FilteredBUSet],[FilteredAccountSet])))ON ROWS,
{[Measures].[Total Revenue],[Measures].[Total Expenses]} ON COLUMNS
FROM Profitability
need to find how to pass paramaeter thru this query
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|