Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Dynamic Columns in BI Services?

Hi,

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

a

Region 2 selected

Office 1 | Office 2 | Office 3

a

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.

Thanks

David

Former Member
Former Member 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.

http://blog.davidg.com.au/2012/06/bi-services-with-crosstabs-variable.html

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question