Passing a parameter to the same query that just ran (SSAS Datasource)
I have a "dashboard" which looks at the entire corporation, then has text boxes as link that will filter down to the specific business units. Previously I was doing this with standard SQL queries, but now I am converting the report to a cube data source. Here is the code SELECT NON EMPTY { [Measures].[Development Ratio TRE], [Measures].[Cash Flow Before Principal Projection-EBDT], [Measures].[Cash Flow Before Debt Service Budget-NOI], [Measures].[Cash Flow Before Debt Service Projection-NOI], [Measures].[Cash Flow Before Principal Budget-EBDT], [Measures].[Cash Flow Before Debt Service-NOI], [Measures].[Development Ratio CRP], [Measures].[Cap Ex], [Measures].[Cash Flow Before Principal-EBDT] } ON COLUMNS, NON EMPTY { ([Property].[SBU Property].[SBU Property].ALLMEMBERS * [Property].[Property Name].[Property Name].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@PropertySBUProperty, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Ledger].[Ledger Code].&[LL] } ) ON COLUMNS FROM ( SELECT ( { [Account Period].[Fiscal Hierarchy].[Fiscal Year Number].&[2010] } ) ON COLUMNS FROM [Property Inventory]))) WHERE ( [Account Period].[Fiscal Hierarchy].[Fiscal Year Number].&[2010], [Ledger].[Ledger Code].&[LL] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS On the Action of the text box I have the parmeter name and the value being passed, but it's not refreshing the report and it wants me to select the value from the drop down. What am I doing wrong?
November 30th, 2010 12:18pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics