I have an interesting problem and I am looking for some suggestions on how to solve. We have a reporting cube that has an Account and Cost Center dimension. The combination of these 2 dims make up a P&L line item.
To create this in a UX view we have used tuples to define the row set, and we have added a subview which pulls the line description from another cube.
We are now trying to figure out a scaleable way to manage the row formats. We have standard scss class built for this, SubTotal, GrandTotal, Etc. The only way we we have found to format the rows is to add the class references manually via the advanced settings.
Some options I have thought of
- Building a cube that joins these 2 dims together, this would take a while and require quite a bit of testing so we want to avoid this.
- Using a horizontally sectioned view since 1 of the dims changes, not currently supported by UX
- store the formats in the same cube that houses the descriptions and reference them from there. Not sure how this could work as UX can’t pick up formats from data cells.
Any other ideas?