Question:
We have a cube being loaded from ODS. While loading the cube i am only taking materials which end with NR or FR. Also i have a Flag defined to identify NR and FR materials from their last two characters.
We need to develop a report with only NR materials with some key figures in it and for one Key figure they need the corresponding FR materials value.
Ex of report they want...
Material No Unres Quantity Total Quantity Average usage
T003NR 10 20 (They want T003FRmaterial's value)
As this report will have global filter for NR value, i was wondering how i can get corresponding FR material's value.
Please do advise....
Answer:
off the top of my head; i would take the easy way out.
have two sets of key figures in your cube (FR-material values for NR-materials). in you update rules from ODS to cube create a start routine that generates a second transaction every time is encounters an FR material where it changes the material number to the corresponding NR and places the key figure values into the 2nd set of key figures (mentioned above).
when you run your query the NR materials will have the NR values (normal KFs) and the corresponding FR values (2nd set of KFs); when a FR material display you will see the FR values (normal KFs) and zeores for the 2nd set (which could be blanked out with zero surpress).
_________________
when in danger or in doubt, run in circles, scream and shout.
Answer:
Do you want me to use the Return table concept and a add a new row for the NR material with FR keyfigure values. Please do correct me if i am wrong....
Answer:
i would just use a start routine where i loop through the datapak checking for the material name then send the single or double transaction into an internal table (e.g. datapak1) then delete the single transaction out of datapak at the the end of each loop; when the loop is complete move datapak1 into datapak and its done. however, a return table might be the proper way to perform the task. i haven't compared the two methods, so i don't really know which is more efficient.
_________________
when in danger or in doubt, run in circles, scream and shout.
Answer:
Thank you so much. I will try and let you know...
Answer:
Hi,
Use a variable on the Material Characteristic. This variable needs to be fed by a Replacement Path Query. This second Query may fetch the FR Materials and feed it to the first Query. The first Query then displays the NR Materials from other selection variables.
Regards,
Chayan.