cancel
Showing results for 
Search instead for 
Did you mean: 

Will FIORI support SAP Bex Query that has Structures, Cell Definitions

Former Member
0 Kudos

Hi Gurus,

I am currently working on a complex SAP BEx Query that sources data from an ADSO (on top of ACDOCA Table to get the actuals data)and Open ODS (on top of ACODCP to get the real time data). The Query has Row & Column Structures, Calculated Key Figures, Cell Definitions, Exceptions. I have suppressed messages and warnings since the Query displays multiple currencies and Units.

The Query works good when executed in RSRT and Analysis for Office. We have linked the same Query to the FIORI and when i open the same Query from the FIORI Tile the Query doesn't open.

1. Will FIORI Support SAP BEx Query that has Cell Definitions? if not what is an alternative to this one.

Can you let me know if anyone had experienced the similar requirement if so how did you resolve it.

Appreciate your inputs on this.

Regards

LD

Accepted Solutions (0)

Answers (1)

Answers (1)

nora_roch
Employee
Employee
0 Kudos

Hi LD,

Fiori apps usually access the BW query with an ODATA Service and there is the limitation that queries with two structures and thus with cell definitions cannot be used, see SAP Note: 2367553.

I am not aware of any workaround here, but I would recommend to check the possible options BW ODATA Queries in the SAP Community Wiki. Maybe one of the samples could help to implement your requirement.

Cheers,

Nora