Question:
Hello Experts,
I have a problem with my reports.
The probelm starts with compounding of InfoObject Item with Verson.
Ths scenario is as follows.
We have an ODS which stores the financial data.
We have Item and version as part of ODS key. We store amount for each Item depending on version. There are 2 versions. European Version and US Version depending on various tax rules. The amount in case of European version is stored as full value and the amount in case of US version is stored as delta value. We are supposed to calsulate US full value as sum of European full value and US delta value.
Now
I have a report which fetches European Full vaue in 1st column and US Delta value in 2nd column. and a 3rd column with a formula to calculate the sum.
The data in ODS look like this.
Item Version Amount
1001 EU 1500
1001 US 200
The above report looks like this
Item___EU Full_____US Delta____US Full.
EU/1001____1500_____0_____1500
US/1001_____0_____200_____200
as the infoobject Item is compunded with version.
But i want to show like this.
Item____EU Full____US Delta____US Full
1001_____1500_____200_____1700
How can I get rid of this compounding in the report.
Answer:
You can get rid of the compounding in the display, but not, as far as I know remove the duplicate line.
To remove the compound char put version as a drilldown before item, then hide it via properties.
Answer:
How about this?
- Create an InfoObject Item2, similar to Item but not compound.
- Add Item2 to InfoObject Item, as a navigational attribute.
- In the upload of master data for Item, load attribute Item2 with the same source as for Item.
- Activate navigational attribute Item2 in the cube.
- In the query, report on Item2 and not on Item.
Leandro