Skip to Content
Former Member
Nov 01, 2013 at 02:17 PM

Variable to count Merged dimensions



In my Webi report, I do not have any measures, only the characteristic account hierarchy. One account hierarchy is sourced from SQL (via universe) and the other account hierarchy is sourced from BW query (via BICS). The 2 hierarchies / dimensions for account are merged successfully in WebI. When I display the 2 hierarchies (2 columns in single table), it shows me only those rows (by text) that match, Those rows that do not match are not displayed, which is good.

How can I get a count of the rows after they are merged? I wanted to create a new variable that will count only those rows that are merged succesfully. I have a variable that tells me the count before merging the dimensions.

Hope my Q makes sense.

Thank you