on 06-09-2011 6:41 PM
Dear Experts,
When defining two colkey ranges =EVRNG(A8:B9,C8:D9)
Can I restrict my AFTER RANGE value only to the sencond range (C8:D9)
I mean, make that the columns created by the EVAFTER only applys after the whole colkey range
display the column corresponding to the first range, the the column corresponding to the second range and
then the column generated by the EVAFTER.
Someone could help me limiting this After Range values to second col key range?
Thank you veeeery much.
Hi,
You can not have multiple afterrange definitions for the same dimension within single EVDRE. What you could do is to combine several EVDRE reports sharing the same rowkey range and have separate colkey ranges. In this way you can define row and first column set expansions in one report definition and second column set expansion in another whilst pointing the rowkey to the one used in 1st report.
Hope this helps,
Madis
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you very much Madis,
I will try to build two EVDREs as per your suggestion, but my concern is.
Expansions between two EVDREs are compatible I mean, if I require following structure:
col1 col2 col3 (difference) col4 col5 col6 (difference)
ACC 1 ACC 1 Difference between column 1 & 2 ACC 2 ACC 2 Difference between column 3 & 4
2011.JUN 2011.OCT Difference between column 1 & 2 2011.JUN 2011.OCT Difference between column 3 & 4
V100 V200 Difference between column 1 & 2 V100 V200 Difference between column 3 & 4
I could filter time and version for first column in the first EVDRE and TIME and VERSION for secon column in the second EVDRE introducing the AFTER RANGE in the second EVDRE obtaining the desired result for the first section, for the first required account.
But what would it happen with second section, with ACCOUNT 2...I am afraid the first EVDRE will retrieve all accounts for TIME 1 and VERSION 1...and the at the end the second EVDRE will retrieve all accounts for TIME 2 and VERSION 2 , with out being able to compare values from selection 1 (TIME 1 and VERSION 1) versus selection 2 (TIME 2 and VERSION 2).
Thank you very much for your help.
Looking forward to hearing from you.
Best Regards.
Thank you very much Madis,
I will try to build two EVDREs as per your suggestion, but my concern is.
Expansions between two EVDREs are compatible I mean, if I require following structure:
col1 col2 col3 (difference) col4 col5 col6 (difference)
ACC 1 | ACC 1 | Difference between column 1 & 2 | ACC 2 | ACC 2 | Difference between column 3 & 4 | |||||
2011.JUN | 2011.OCT | Difference between column 1 & 2 | 2011.JUN | 2011.OCT | Difference between column 3 & 4 | |||||
V100 | V200 | Difference between column 1 & 2 | V100 | V200 | Difference between column 3 & 4 |
I could filter time and version for first column in the first EVDRE and TIME and VERSION for secon column in the second EVDRE introducing the AFTER RANGE in the second EVDRE obtaining the desired result for the first section, for the first required account.
But what would it happen with second section, with ACCOUNT 2...I am afraid the first EVDRE will retrieve all accounts for TIME 1 and VERSION 1...and the at the end the second EVDRE will retrieve all accounts for TIME 2 and VERSION 2 , with out being able to compare values from selection 1 (TIME 1 and VERSION 1) versus selection 2 (TIME 2 and VERSION 2).
Thank you very much for your help.
Looking forward to hearing from you.
Best Regards.
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.