Hi,
I am working on an unfinished report which is built on a multiprovider. MP has 4 base cubes : FIAR, Sales Item, Header, Billing Infocubes.
Report has 35 Chars and out of which 12 are coming only from Sales Item Infocube. Key figures include only RKFs from these ICs with multiple characteristics restrictions on each RKF ( coming from FI, SOI, SOH and SO-Billing ). Not all chars are available commonly in all ICs.
Becase of those 12 characteristics as they are not common in all ICs, it shows duplicate records for them. Tried applying constant selection ( by putting uncommon Chars to RKFs and restricting them by # and applying constant selection but this has led to missing of data from report as each RKF has further more charateristics restricts ).
Client is not at all satisfied with BW now and it's reporting capabilities as they are expecting one row per customer in this report which is not coming or if it's coming data goes missing due to customer selection.
What could be the best alternative for this scenario ?
warm regards,
AN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.