on 07-24-2018 7:14 AM
Hi Experts,
I have an requirement to show status as live and final for a contract account based on user input date in runtime by checking the user input date with validity dates in SAP BEx.
I have stored this information in DSO and derived keyfigure showing 0 for final and 1 for live status along with validity dates. I have added this DSO in my multiprovider along with cube.
And then in BEx query designer , i created a formula keyfigure and put my live/final keyfigure in it and applied exception aggregation summation on Contract account. The query is showing correct results.
but the users doesnt want live final status to be shown as keyfigure. The requirement is to show as characteristics only.
As there is an limitation in SAP BEx to apply exception aggregation on characteristics, could you please let me know how can I achieve this requirement in backend or frontend ?
I dont want to use infoset. If there are any other way please do let me know.
Hi,
I think this will work. I used this a lot in my projects.
Regards,
Loed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
you can try at infoobject maintenance, at the calculation/aggregation tab to create an exception aggregation and add a characteristic as reference values. Perhaps it can work in that way, if I understand your requirement right.
Regards,
Regys
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sounds a bit like a virtual char to me
could you check
https://danielnurindra.wordpress.com/2009/03/30/creating-virtual-characteristic-using-badi/
whether this could help you?You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.