on 07-08-2013 8:07 PM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 !!
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
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 |
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Mike,
not forgotten. working on it. should have something early next week
ingo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 :-))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.