Attached example - Circular Reference problem

[#1]

Hi,

Please see attached example of a Sample app that demonstrates circular reference problem. Due to circular reference, selecting ABS from Financial (Level #2), show plan as 0 instead of 1700

Can someone please help me resolve this issue? I cannot create a link table based on both Financial and Team. Both these tables has huge no. of records and cross cartisan table is not possible between these two.

I searched thro the forums for Circular reference issue but could not find satisfactory result. I hope the attached example would help to understand the issue.

Thanks in advance!

Regards

[#2]

Hello,

I modified your script and load the PLAN_DATA table twice.

Maybe this put you in the direction to solve your problem.

Rainer

[#3]

rfa - thanks for the reply..

I am not sure if the attached solution is working. I understand that you wanted to point me in a direction to use Qualify, but so far I am unable to implement to get it work.

In the solution that you posted, the CV by Teams chart should display below Plan nos when ABS is selected

461243 (UK) 800
847215 (SINGAPORE) 900

This totals upto 1700. However, in your solution, both UK and SINGAPORE shows 1700 each.

My requirement is to calculate plan nos. with any Team (level 1) and Financial (level 2) combination. Would appreciate if you can provide some guidance..

[#4 · Accepted solution]

Please see the attached file.May be you could use the mapping to combine CV and Plan data together...not sure if there a better solution to this.

Thanks.

[#5]

Raj,

Yes, it did work! Only issue I had was that I was creating the maps based on QVD files and it wasnt working as expected. Found somewhere in the forum that maps do not work when loading data from qvd, so added a where condition 1=1 when loading data from those particular qvd files. But otherwise, solution worked fine! Thanks a lot!!