Hi All,
We have already developed webi report (Profit center wise couple of measures)
User came with new requirement, he want same report but region wise.
He gave us one excel file with Profit center and region mapping.
We added that excel file to report as new query.
Merged existing profit center object with the object from excel file.
And replaced Profit center object with Region object in report.
all measure start showing same value for every record.
so we used ForceMegre() function for all measures in Webi report to get the correct data.
Now data is coming right but the Total values of all the measures are not coming correct.
How to resolve this issue?
Thanks in Advance
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.