cancel
Showing results for 
Search instead for 
Did you mean: 

Exception Aggregation in SAP BeX

abhimanyu_sharma
Contributor
0 Kudos

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.

Accepted Solutions (0)

Answers (3)

Answers (3)

Loed
Active Contributor
0 Kudos

Hi,

I think this will work. I used this a lot in my projects.

https://blogs.sap.com/2015/06/29/how-to-derive-status-column-like-openclose-in-bex-designer-without-...

Regards,

Loed

abhimanyu_sharma
Contributor
0 Kudos

This is cell definition and it will work if you have fixed layout in the report.

Loed
Active Contributor
0 Kudos

NO. It will work even if you don't have a fixed layout. Try it first to check.

Regards,

Loed

regysm21
Active Participant
0 Kudos

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

kohesco
Active Contributor
0 Kudos

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?
abhimanyu_sharma
Contributor
0 Kudos

Thanks Koen,

Just want to know if I can read user Input varibale passed by user in BEx query in the virtual characteristics? as i need to display the values in the report based on user input.

kohesco
Active Contributor
0 Kudos

Hi check

raf.boudewijns4 answer on this one:

https://archive.sap.com/discussions/thread/3724994