Bex Analizer & Query designer

[Former Member]

Hi!

I am using SAP in my company and I have realized I have Bex Analizer Excel and Query designer installed in my computer.

I am trying to use Bex Analizer add-in in excel to connect to either SAP or BI portal to retrieve information but i am not able to do it.

When I open to create a new query, there is anywhere where i can find the information/cubes/tables with the information.

I have been contacting people from IT and SAP in the company (including headquarters) and apparently none of them know how the tool work and so none of them is able to show me or explain me beacuse no one in the company uses it.

I work in the finance department, therefore using a lot of information from SAP and regularly extractions in same format so I am trying to automate this processes using this tool.

Is there any one that could guide me when doing it?

Maybe I need authorization from my company to access the information (even if i have the tool installed)

Indeed it is a shamed that it is there and we cannot use it. I am sure it has a lot of posibilities and I am willing to learn them, but of course, I need to get to where the information is, so I am not able right know to create querys.

Even with the Bex portal, I can create querys and save them, but they are saved in the portal, there is no option i can use to export this query to my desktop and then open it with query designer for example.

Thanks in advance,

[Former Member]

I am a very inexpert user of SAP, I am going to try to explain exactly what I have and need…

If I go into my company’s portal to Business Explorer, then go to My Bex Portfolio and select a query I have created there.

I can see in “details of the query” my Portal component and the object ID. If go to Save as and see the properties of my query, I see the type (KM Bookmark), Description and Technical name.

Then… If I open Business Explorer Analyzer, an excel  appears, I go to the Add-ins tab, in menu commands, Bex Analizer button, click on Open query:

First it appears a box to select SAP Logon, System. I select PAF that is the one I connect in SAP normal system. Then ask for my user and password. After that, the open query window appear and the options I have on the left are: Find, History, Favourites, Roles and Info
Areas. In all of them it says No objects found.

Here is when the cubes or report or querys should appear… My created and saved query should be somewhere… where?

Is this about authorizations? Wich kind of authorization do I need?

If I go to the excel again, and instead of open query I click on Tools, create new query, I have a wizard that says info provider on the left, then filters, then default values, rows, columns…. So… here I can create a query but… where is the information to select? Info provider is empty.

• Maybe I don’t have the authorization to see information in Info provider
• Maybe my query is not in the PAF system.
• Maybe the general info is not that system and is in other one

[RamanKorrapati]

Hi,

Might be you don't have authorization to see the existed query's at analyzer. Please check with your Basis team which roles your user id have.

At designer if you want see cubes, then click on Create(white patch icon) there you may info area/info cubes. choose your info cube and develop report.

Thanks

[cornelia_lezoch]

Hi Maria,

it is not really clear what you mean by "I am not able to do it".

What exactly is it that you are missing?

Do you have the SAP GUI installed?

Do you have SAP BW systems available in your sap logon?

do you have user ID and authorizations to your BW system?

if yes, you could log on to the system and start transaction RRMX to start the bex analyzer.

when starting the analyzer - do you see these tollbars?

can you connect to your BW system? (second toolbar line, second symbol from the right)

If you can not see the tollbars, you might need to allow macros in excel.

any other questions you need to be more specific about the single questions.

best regards

Cornelia

[cornelia_lezoch]

about your question where to find your cubes

when going to "Open Query" (NOT open workbooks) you should see this

the cubes you will find under "InfoAreas".

If you do not see it or no cubes underneath, then you are missing authorizations.

regards

Cornelia

[former_member199691]

Whatever query you use in Bex Portal or save there as views, you should be able to open those queries in both Query Designer and Bex Analyzer.

Query Designer is the report building tool. Queries created in query designer can be exeuted both in web as well in Bex Analyzer.

Advantage of Bex Analyzer is that

- front end is excel based so you dont need to run the report in  web and then export it to excel.

- in web, there is a time out limit. So if you are working with a report/data that takes more time than your time out limit in web, you can use Bex Analyzer to run that report.

- you can create workbooks. what that mean is that in one sheet you can have the query output and in other sheets you can create pivot, charts etc using that data. you can also use Bex Analyzer workbook to execute mutiple reports at once and then use that data for futher reporting (instead of opening and executing report one by one in web).

you can also save your workbook with pivots and graphs, so next time you just need to open and refresh it and your charts, pivots will be refreshed with latest data from system.

In the Add-In tab, click on folder icon > open queries > you can search by role and execute those queries. Search for Bex Analyzer user guide, you can go through it to get an understanding of how to work with analyzer.

Regards,

Gaurav

[former_member182470]

Queries can be created by connecting to BEx Query Designer. You should have access to create queries by connecting to SAP BW System via Bex Query designer.

You should contact the people who have installed it to use it properly. Don't you have any BI team to assist you?

BEx ANalyzer or BI Portal is to run reports and check your data. This is just to view the data by the queries which are created in Query designer.

[RamanKorrapati]

Please search on google.

http://lmgtfy.com/?q=bex+analyzer+user+guide

Thanks