As you can see the design of this site has changed! We are also changing the way people interact on this site. From now on -
1. All the help needed postings should be done in the forums.
2. Blogs will only be used for writing serious blog posts. Any help needed questions posted under the blogs will be deleted - please use the forums for that!
3. Job postings will be done by registered recruiters. It will continue as a free service.
These rules are to make your networking better and easier.
Sorting BEX Report
I am fairly new to BW and can't figure out how to get a report formatted the way our
client has requested.
When I drag Dimensions to the Rows, the Sort Hieararchy by Default is from left to right and
the Contents of the Rows will always be placed in the left most columns in the Worksheet. Is there any way to move things
around and specify a Sort Hierarchy other than the Default.
For example, we have a report similar to this where the Sort
Hierarchy is Material within Forecast Grouping code:
Forecast Material Available
Quarantined
Code Inventory Inventory
--------- --------
----------- ------------
AAA 1234567 10,000 100
AAA 1235678
5,000 0
AAB 1237890 15,000 48
AAC
1122334 400 0
AAD 0055667 900 12
AAD
0123568 750 0
Where the Dimensions Forecast Grouping Code and Material are
in the Rows and the Key Figure Inventory is in the Columns.
We have been asked to maintain the same Sort Hierarchy
but to move only the Forecast Grouping Code to a column to the right of the Key Figures. So the report would look like
this:
Material Available Quarantined Forecast
Inventory
Inventory Code
------- ----------- ------------ ---------
1234567 10,000
100 AAA
1235678 5,000 0 AAA
1237890
15,000 48 AAB
1122334 400 0
AAC
0055667 900 12 AAD
0123568
750 0 AAD
Is there any way to accomplish this?
Thanks,
Mike
