Regarding Exceptions in Report

[Former Member]

Hi Experts,

Need help to achieve following requirement.

We have ORDER & DELIVER fields, now we need to Highlight DELIVER column if it is less then ORDER.

i have created a formula "deviation" and it is working fine. but it is not highlighting the column DELIVER instead it is highlighting Deviation column.

ex, In this case i need to highlight 1st & 2nd records of deliver column.

ORDER          DELIVER        DEVIATION

100                    90               -10                        

200                   200                0

10                     0                  -10

Your early responce would be highly appreciated.

Thanks.

Prashant

[john_lang · Accepted solution]

Hi Prashant,

Have a read of http://help.sap.com/saphelp_nw70/helpdata/en/43/21b4cd14cd06f4e10000000a422035/content.htm

See the section labeled “Display/Target” and make sure you understand the restriction about this feature not being available in BEx Analyser.

Kind regards,

John.

[Former Member]

Hi Prashant,

In BEx Query Designer, go to Exception Panel. Select your exception and got to properties.

In properties go to Display tab - Key Figure selectedf should be Following Structure Element and In drop down select DELIVER.

Regards,

Kush

[Former Member]

Hi Kush,

still its not working, in the exception properties i checked "exception effects data cell"-->following structure element-->from the drop down selected "Deliver". Below this checked "Exception Affects Characteristics Cells"--->Rows.

Any idea whyu its not working.

Regards.

Prashant

[Former Member]

Hi Prashant,

Don't select Checkbox for "Exception Affects Characteristics Cells"--->Rows.

It will work.

Regards,

Kush

[Former Member]

Hi Prashant,

Will creating Exception have you Defined Exception value correctly in general tab for exception ?

I think you missed to do that... Select New in Exception Value in General tab.

Dropdown Alert Level and Operator will be activated... Give your condition Value and select

Bad for Red color

Good for Green color.

And click transfer.

Regards

Kush

[Former Member]

Hi Kush,

Still no luck, still DEVIATION column is getting highlighted.

Below are the properties of exception created.

a) Exception is active

b)Definition tab-->Deviation , Selected--> Before list calculation under Time of evaluation

c)Display Tab--> as discussed above

d)Cell restriction: nothing defined by default radio button is checked for Exception affects everything.

Regards.

Prashant

[Former Member]

Prashant,

On General tab be sure to add Exception value. Have you defined Alert Level, Operator and value.

If already added, it should be available in "Define Exception Value" panel.

Regards,

Kush

[Former Member]

OK. Prashant can you just attch screenshot for all thje tabs. Tht would be easier to find the prob.

Regards

Kush

[Former Member]

Hi Kush,

i think it will not work in Analyzer but after executing the query on Web its working.

Regards.

Prashant