Multi-value dimension onto a single row
source link: https://community.sap.com/t5/technology-q-a/multi-value-dimension-onto-a-single-row-in-multiple-columns/qaq-p/13596387
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
2 weeks ago
- last edited
2 weeks ago
Hi. I have a service order with multiple operation lines. That service order is made up of many 'Account Indicator' 1, 2, 3, 4 etc, 1 for each line. On each service order operation line there is a field called 'User Field 00'. In the field called 'User Field 00' is a code, that code will change for each service order line/Account Indicator. In BI I want a single line for each service order and a column for each of the 'User Field 00' code for each of the different 'Account Indicator', so if a service order had 6 Account Indicators I would want service order number in the 1st column and then the User Field 00 is individual subsequent columns . What are the variable(S) I need to create for each column? I have tried various variations of '=If ([Account Indicator]) = 0 Then ([User Field 00]) ForEach ([Service order + AccIndi]).
Any help would be appreciated.
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK