on 10-04-2016 7:52 PM
I am trying to build a report like this :
Entity1
Aug 2016 Q4.2016
YTD Periodic Variance
Account (Row)
I am getting it as (depending on the order in column axis)
Entity1
Aug Q4.2016
YTD Periodic YTD Periodic
Or
Entity1
YTD Periodic
Aug Q4.2016 Aug Q4.2016
How can I get my top requirement, that too in one report (I know I can create a second shared report and get it but it wont help in my case because I want to provide for expansion of entity by double clicking it and looking at the three columns for each expanded entity.
Would greatly appreciate your thoughts. We are on 10.0 SP25.
Hi Ram,
Look at my above reply to Vadim for the approach to be used for your report requirement. Let me know if you need anything else.
Regards,
JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
JP and Vadim,
Thanks for the effort.
JP, I am not getting the same result as you have. In the second column when I cell reference (using Activate Member Recognition) for Time (2016.Q4) and Measure (Periodic), the report splits into 4 columns as follows:
Entity1
2017.01 2016.Q4
YTD Periodic YTD Periodic
Whereas I am looking for
Entity1
2017.01 2016.Q4
YTD Periodic
I want to have variance in the third column (difference between second and first) with the ability to double click and expand on Entity1.
JP, you seem to have got it right. I too built the first column using edit report and second column for time and measure using cell reference just as you said. Can you share your screenshot before entity expansion please.
Thanks.
Hi Ram,
I will post the screenshots tomorrow. Meanwhile i have created report using edit report using only 1 member in all the 3 dimensions with "Member only" relation. Then Activate member recognition on pass th cell refernce for time...then measure...and then tested the expansion.
For local member... i have created local member by attaching it to member Periodic and formula as =D9-C9.
Regards,
JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Vadim,
I just tested in my system...and the report looks to be working with Entity expansion by double clicking....What I did was I only gave cell reference for Quarter and Periodic measure and others selected through Edit report. See the below result upon expansion of Entity (Product)
Can you confirm this from your side?
Regards,
JP
Sorry, but requirements are not clear!
What do you mean by Variance?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.