Dynamic Columns in BI Services?
I was wondering if anyone has figured out a work around to have a dynamic set of columns working for BI Services
For example I have a cross tab where the columns change depending on what region was selected
Region 1 selected
Office 1 | Office 2
Region 2 selected
Office 1 | Office 2 | Office 3
Unfortunately in Xcelsius if I try to bind 3 columns, the first selection values will come back all messed up.
I was thinking if there were some way to put buffer columns in the back somehow so that we always retreive a consistent amount of columns?
If anyone can shed some light on this it would be greatly appreciated.
David Gilbertson replied
I've written a short post on how to do this. (I see you've read it already David.)
The BI Service contains values for the number of columns and rows it contains. Using Excel formulas you can re-create a varying column Webi block in the spreadsheet.