on 2009 Sep 20 3:31 PM
Hello,
Was wondering the best way to approach the following scenario in bex query designer.
_______01/2009----02/2009--03/2009--04/2009----05/2009
KF 1--
A5
KF 2--
B5
Explanation of KF 2:
B1 = A1A2A3
B2 = A2A3A4
B3 = A3A4A5
Any help on calculating KF 2 would be great. Thanks.
Hi,
Having fiscal period in drill down or drill across and having a keyfigure to populate three months value at single cell is impossible.
You have to data in such a way you requested in dataprovider else you have to go for double structure queries
ie cell editor options in query.
Cell Editor will be the best way for you to implement this. Create two structure in the query one in rows and one in columns.
and you can proceed on restricting each cells with the formulas you need.
Thanks,
Arun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
10 | |
10 | |
10 | |
10 | |
8 | |
8 | |
7 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.