cancel
Showing results for 
Search instead for 
Did you mean: 

Migration of BEx Workbooks to use BO OLAP Connections

0 Kudos

Hi all,

         I am working on a project to convert our existing BEx workbooks to Analysis Office workbooks.  We are planning to save our workbooks on the BOE server.  We would like to use a BO OLAP connection instead of a local (SAPLOGON.INI) connection.  But we're running into issues, and i just wanted to verify I'm not missing anything.

     When we convert the workbook, Analysis Office brings the connection in as a local connection (using the saplogon.ini file connection).  I figured out how to change this connection to point to the shared OLAP connection we created.  However, when we do this, the workbook resets to the default view of the query.  So any customization we did (adding/removing of columns, etc) from the default query view - is completely lost.  And that kinda defeats the purpose of doing a workbook migration.

     Does anyone know if it's possible to switch to use an OLAP connection after migrating a BEx workbook - without losing the customization done in the workbook?

     Thanks in advance!

Accepted Solutions (1)

Accepted Solutions (1)

IngoH
Active Contributor
0 Kudos

Hello Michael,

when you change the connection from the Analysis Workbook, I am not surprised that it goes back to the initial view.

remember - you are not doing a migration, you are changing the data connection.

Did you try to create an Analysis View on top of the connection and to re-open the Analysis View ?

regards

Ingo Hilgefort SAP

0 Kudos

Thanks for the quick response, Ingo.

No, I had not tried to create an Analysis View on that connection.  But I did just try it, and it would not give me the option to save an Analysis View from that workbook.  I'm assuming that's because the workbook is still using the SAPLOGON.INI entry as the connection, not an OLAP connection stored in the BOE.

0 Kudos

Hi Michael,

To save as an Analysis View you must do a right mouse click while you pointer is in the KF grid. Hope this helps.

Regards,

John B.

0 Kudos

Hi John,    

     Yes, I am able to create an Analysis View from a workbook that is created on an OLAP connection stored in the BOE.  However, if the connection is a local connection directly to a BW system (using a SAPLOGON.INI entry), the Analysis View option does not appear. 

     And that makes sense.  If it allowed me to create and save an Analysis View on a local connection, and i tried to consume that view in Analysis OLAP, how would it work?  Analysis OLAP does not have access to my local PC to read the saplogon.ini file.

     And that is the problem i'm trying to solve.  I'd like to migrate a BEx workbook over to Analysis Office, and also switch the connection from a local connection to use an OLAP connection hosted in the BOE.  Then i would be able to do fun stuff like Analysis Views. 

Thanks,

Mike

Former Member
0 Kudos

Hi Mike,

We are also planning to migrate from BEx queries to OLAP for Analysis tool.

However, i am confused on how to switch to a shared OLAP connection? Kindly help. Thanks!!

Regards,

Tilak

0 Kudos

Tilak,

    Are you talking about using Analysis, edition for OLAP?  Or using Analysis, edition for MS Office?

If you're using Analysis, edition for OLAP, I don't believe there is a migration from BEx workbooks.  Analysis OLAP can access BEx queries directly.  But it has to be through an OLAP Connection saved in the BOE.  So to do that, go to your CMC, go to the OLAP Connections section, add a new OLAP connection pointed to your BW system (or HANA, etc).  Then open Analysis, edition for OLAP and create a new workspace.  If it prompts you for a connection (it will if you have more than one OLAP connection), select the OLAP connection you just created.  That should be it. 

What I'm trying to do is migrate a BEx workbook to an Analysis Office workbook, and have it use an OLAP Connection that is saved in the BOE. When you migrate a BEx workbook to Analysis Office, it brings over a "local" connection to BW. It does not use the OLAP connection saved in the BOE. And that's exactly what I'm asking for help with.

Hope that helps a little.

Mike

Former Member
0 Kudos

Also Mike, in our case customer wants to migrati from BEx queries to  Analysis, edition for Olap?

So, what do you think we need to do. Is it like open the BEx queries through Analysis OLAP and save them in BOE? Please help..

TammyPowlas
Active Contributor
0 Kudos

Tilak,

BEx queries are a data source to Analysis OLAP so your client wanting to migrate from BEx queries to Analysis OLAP does not make sense.

Regards,

Tammy

Answers (7)

Answers (7)

david_stocker
Contributor
0 Kudos

To add to what Ingo just posted, when you change the connection of a data source, Analysis always throws away your navigation state and reverts to the default.   This is a safety mechanism.  The user might be switching connections for the same query (as you are going) or moving to entirely incompatible data sources. 

Unfortunately, in your particular use case, the safety mechanism is neither necessary nor desirable.  I second the notion that you add it to idea place.

Cheers,

Dave

IngoH
Active Contributor
0 Kudos

Hello Michael,

the good news - I have an answer.

the bad news - what you are looking for is not possible yet.

When you change the connection details of a workbook, the workbook will get reset to the initial view of the BEx query.

I would suggest you place this onto IdeaPlace for Analysis, edition for Microsoft Office and I am sure you will get lots of votes quickly.

regards

Ingo

0 Kudos

Thanks, Ingo!  I'll do that.

0 Kudos

We were able to set the safety belt via the following

To create Safety Belt

SE38> ‘SAP_RSADMIN_MAINTAIN’> Execute

Specify OBJECT= BICS_DA_RESULT_SET_LIMIT_MAX

VALUE = 4100000(cells) and click insert (We are running at 4.1 Million max cells)

To view Saftey Belt settings

SE16 >
“RSADMIN”>
BICS_DA_RESULT_SET_LIMIT_MAX

Former Member
0 Kudos

Thanks John. But we don't want to do that on BW system level, as it works perfectly in query side.

What we want is , to restrict this on tool level (ie: Olap, Analysis).

Do we have any settings in OLAP Analysis where we can restrict the number of List of Value output for a particular dimension prompt?

Hope, i am making sense. Thanks for your help !!

IngoH
Active Contributor
0 Kudos

Hi,

take a look at note 1416952.

Starting with SAP NetWeaver BW 7.01 Support Package 09 / SAP NetWeaver BW 7.30 Support Package 3 customers can use the BAdI RSR_VARIABLE_F4_RESTRICT_BADI to use a set of criteria to restrict the list of members for an input screen. For more information, see F1 help for this BAdI (transaction SE18, enhancement spot RSR_VARIABLE_F4_RESTRICT )

Ingo

0 Kudos

Hi Tilak,

From the AQ admin guide

HKEY_CURRENT_USER\Software\SAP\AdvancedAnalysis\Settings\DataSourceResultSetSizeLimit = -1, n or empty (default)

This setting defines the maximum number of crosstab cells that are loaded from the server for one data source. If a data source contains data for more cells than defined here, a message is displayed.

The standard value for this setting is empty and the maximum number of cells is 500000.

If you set the parameter to a specific number greater than or equal to 0, you define the maximum number of cells with this value.

If you set the parameter to -1, the setting uses the values defined in the BW system. In a BW system, the parameter is set in the RSADIM table for object BICS_DA_RESULT_SET_LIMIT_MAXHKEY

Hope this helps,

John B.
















HKEY_CURRENT_USER\Software\SAP\AdvancedAnalysis\Settings\DataSourceResultSetSizeLimit
  = -1, n or empty (default)
This setting defines the maximum number
  of crosstab cells that are loaded from the server for one data source. If a
  data source contains data for more cells than defined here, a message is
  displayed.
The standard value for this setting is
  empty and the maximum number of cells is 500000.
If you set the parameter to a specific
  number greater than or equal to 0, you define the maximum number of cells
  with this value.
If you set the parameter to -1, the
  setting uses the values defined in the BW system. In a BW system, the
  parameter is set in the RSADIM table for object
  BICS_DA_RESULT_SET_LIMIT_MAXHKEY
HKEY_CURRENT_USER\Software\SAP\AdvancedAnalysis\Settings\DataSourceResultSetSizeLimit
  = -1, n or empty (default)


This setting defines the maximum number
  of crosstab cells that are loaded from the server for one data source. If a
  data source contains data for more cells than defined here, a message is
  displayed.


The standard value for this setting is
  empty and the maximum number of cells is 500000.


If you set the parameter to a specific
  number greater than or equal to 0, you define the maximum number of cells
  with this value.


If you set the parameter to -1, the
  setting uses the values defined in the BW system. In a BW system, the
  parameter is set in the RSADIM table for object
  BICS_DA_RESULT_SET_LIMIT_MAXHKEY
Former Member
0 Kudos

Thank you so much John for the help.

Former Member
0 Kudos

Hi Ingo,

Thanks for your quick help. However, in the "Background" area the dimension which i am trying to use as a filter has huge LOV set, because of which it gives the timeout error.

As from Database/BW layer it brings loads of record and it's difficult to restrict on the front end OLAP Analysis tool, it's throwing Java dump.

Please suggest. Thank you.

IngoH
Active Contributor
0 Kudos

Hi,

then you should restrict the volume already on the backend in the BEx query or use variables for the restrictions in the BEx query

regards

Ingo Hilgefort

Former Member
0 Kudos

But with that volume of data, we can run the Queries but when i want to add a filter on a particular dimension on Olap Analysis tool (let;s say material master) it throws Java time out error. Do we have any settings on Analysis view to restrict this?

IngoH
Active Contributor
0 Kudos

Mike,

not forgotten. working on it. should have something early next week

ingo

0 Kudos

Thanks, Ingo!  I appreciate the help.

Former Member
0 Kudos

Hi Ingo,

Hello Tammy,

Hi Mike,

Do we have any settings on the OLAP, Analysis to create a background filter in order to restrict the data coming from BW side.

One of the OLAP Analysis view is throwing a timeout ~ java dump because of this. How to overcome? thanks!!

IngoH
Active Contributor
0 Kudos

Hi,

in the Layout Panel you have an area called "Background" which is what you are looking for.

Analysis, edition for OLAP will open initially the Query as you created in the query designer.

Ingo

Former Member
0 Kudos

Thanks Tammy for your quick help.

In that case I think our client is confused. so what do you think they want to achieve out of Analysis for OLAP.

Would they want to replace their current BEx analyzer with OLAP Analysis or it's an additional tool they want to add in their analytic portfolio. Could you please suggest Tammy. Thanks!!

TammyPowlas
Active Contributor
0 Kudos

Tilak - without knowing your client, it is hard to say.  Analysis Office is the "premium replacement" for BEx Analyzer.

Analysis OLAP is the web version.

Former Member
0 Kudos

True!! it's difficult to say anything. However, i have to discuss more with them to understand if they know the value addition thing what Analysis OLAP brings in.

Former Member
0 Kudos

Thanks Michael for helping me to understand this.

It really helped a lot not a little 🙂 i wish i could help you with your issue :-))