one report with two cubes - filter techniques
Posted: Fri Sep 26, 2014 5:21 pm
Problem description
I have a report studio report with a crosstab and a list. Each of these comes from two different cubes. I have a prompt page where the prompt is a tree prompt picklist coming from a dimension in cube 1.
In the crosstab (cube 1), the data item comes from a dimension. In the list report, the data item comes from a measure dimension (cube 2).
How can I get the list to filter from the crosstab based on the prompt value in this case? My thought was to caption the prompt value in the crosstab, and cast the value in the list report. Then set up a master- deail between the two based on these items. I tried this and it was giving me some conversion errors with the casting. The syntax is correct. It just doesn't like it.
How would you recommend I go about this?
I have a report studio report with a crosstab and a list. Each of these comes from two different cubes. I have a prompt page where the prompt is a tree prompt picklist coming from a dimension in cube 1.
In the crosstab (cube 1), the data item comes from a dimension. In the list report, the data item comes from a measure dimension (cube 2).
How can I get the list to filter from the crosstab based on the prompt value in this case? My thought was to caption the prompt value in the crosstab, and cast the value in the list report. Then set up a master- deail between the two based on these items. I tried this and it was giving me some conversion errors with the casting. The syntax is correct. It just doesn't like it.
How would you recommend I go about this?