BO4.0 FP3 Query connection supported Bex Features

[Former Member]

Hi all,

I have searched the internet and this forum but could not find any answers to some challenges I'm having building dashboards. Platform is BO4FP3 using the query connection to Bex queries in SAP BW.

Has anyone managed to acheive the following?:

Bringing in total rows
Handling a Bex structure in the rows (e.g. fiscal period over key figures)
Sorting the record set
Pass values from the sheet to Bex range variables (e.g. 01.2012 - 12.2012)

Also is there a way of inserting data into the spreadsheet in a cross-tab method? (only have to enter one cell range for the whole dataset). At the moment I have to provide a cell range for each column in my queries and there are a lot of columns...

Many thanks in advance,

[former_member184594 · Accepted solution]

Bex queries may not be seen the same as in BO.

1. Bringing totals are not supported on BO side because BO is not using the same logic as Bex tools.

2. What do you mean handling Bex structure in Rows e.g. fiscal year etc? You can use Bex structures in BO without a problem.

3. Customizing sorting is not supported for Bex queries. Your data is sorted automatically in alphabetical A-Z order.

4. Passing values to Bex variables can be a problem in BO. You might get errors. SAP know this problem and planning to fix it with the next release of BO 4.1. Also check the SAP notes below:

BO 4.1 Planned Features:

http://scn.sap.com/community/business-intelligence/blog/2013/01/31/sap-businessobjects-bi-41-update-...

1804169 - XLS 000009 error happens when refreshing Dashboards when it contains Bex query data source and it will return no data after refreshing

1789906 - Unable to manually enter or search a BICS based List of Values in Web Intelligence member selector by value

5. Cross tab is not supported in BO, but there are workarounds for that. You can check the links below

http://everythingxcelsius.com/xcelsius-training/xcelsius-and-business-intelligence-web-services-biws...

http://everythingxcelsius.com/xcelsius-2008/xcelsius-and-business-intelligence-web-services-biws-par...

http://scn.sap.com/thread/1551154

I hope these answers your questions.

[Former Member · Accepted solution]

Thank you Zahid, you've answereed all of my questions.  For number 2)  I actually realised the query has 2 structures in the Columns.  I am guessing that this is not supported.

Thank you again

[Former Member · Accepted solution]

Zahid,

         Quick update that issue number 4 has been resolved in BI 4.0 SP6 Patch 3.

[Former Member · Accepted solution]

hi vijay,

i am also facing the same issue as zahid. I am using query browser to connect to BEx query. I want to pass dynamic values from excel to BEx variable. as you mentioned the issue is resolved in BI 4.0 SP6 Patch 3. i just wanted to know are there any issues with this patch if we install this patch. currently I am using BO 4.1 SP3 Patch 1.

please help.

regds,

rajwinder

[Former Member · Accepted solution]

Rajwinder,

               You are already on an advanced patch level, which should have resolved the issue for you. Passing BEx variables through the Query Browser should be allowed for key values but if it isn't working, you might want to open an SAP hig level ticket for them to look into the patch.