Agreed, although I am not sure if the 100 row count in a Cube View was
just an example or a real-life case, as that would be quite an extreme
amount of rows for one definition. One issue with the use of an
alternate (account) hierarchy is when the un...
HI @Nitishkrish16, You could consider writing an XFBR rule for this in
different variations, depending what style you use to set up Cube Views.
If you would set up the row names as "ROW " and you simply want
to add up the result of those rows, you co...
Hi Andrea, You can put the XFBR in a literal value parameter and then
include that parameter as |!parameter!| in the query. Alternatively, you
can move the SQL query and XFBR logic to a Dataset BR. Hope this helps.
Regards,Paul
Hi Mark, I just tried this on a 7.1.3 instance and the column override
seems to work for me, when the column name has spaces and without using
the square brackets. Are you on a different version, or maybe a row
override on a column is changing it to ...