Info: Cannot process Query "Number of Entries" with 3.x Query Designer
BEx Analyzer: The appropriate workbook to this query has content release 1.2/02.
Message: Do you want to open the 3.x workbook for upgrade? Click "ok" then this text will be shown:
Diagnosis
An error occurred while reading the metadata associated with this query in the workbook. This metadata is stored in two hidden repository sheets: SAPBEXqueries and SAPBEXfilters. The error may have been caused by corrupt metadata in the hidden sheets. It is also possible that these are BW 2.x workbooks that were opened directly in the BEx Analyzer from SAP NetWeaver 7.0.
System Response
Since the metadata was not read correctly, it is possible that the query in the workbook was not upgraded correctly. The upgrade process continued, but there may be consistency issues, which you should check for by refreshing the workbook. If you are working with a BW 2.x workbook, the workbook may not be upgraded at all.
Procedure
First try refreshing the workbook in the 7.0 Analyzer to check whether the query refreshes correctly despite these errors and whether these errors can be ignored. If the query refreshes correctly, the warning can be ignored and the workbook can be saved.
If the workbook does not refresh correctly in the 7.0 Analyzer, check whether it refreshes correctly in the 3.x Analyzer. If errors occur while refreshing the workbook in the 3.x Analyzer, the workbook is probably corrupt. You should then investigate the cause of this in the 3.x Analyzer.
If the workbook refreshes correctly in the 3.x Analyzer, another possible cause could be that the Excel workbook or worksheet is protected. Try unprotecting the worksheet or workbook and upgrading it again in the 7.0 Analyzer.
If the workbook was created using 2.x Analyzer, save the workbook again in the 3.x Analyzer and try opening it in the 7.0 Analyzer.
If none of these solutions resolve the problem, there may be other compatibility issues between the 3.x and the 7.0 Analyzer. In such cases, check whether you can make adjustments manually with the 7.0 Analyzer to solve the problem.
There is also HR content Web Template, like this one: 0TPLS_0PA_C01_Q0103_V02
Content Release 3.5/03
When opening the Web Application Designer 3.x I got a failure message:
"The selected template contains HTML fragments, non-supported items or is not designed to be edited with the Web Application Designer. Use the functions "Upload to Server" or "Download from Server" and edit the Web Template in an external HTML editor. You can also edit the Web template in text mode by selecting "Text mode" in the toolbar at the bottom of the screen if you are already in text mode, you can exit by closing the Web template"
This is very strange as I am already in a 3.x Web Application Designer.
Do you have any idea why this message is created? Before opening this template I have already migrated the 3.x queries to 7.0 queries which are also data providers for web templates.
We activated HR and deliberately did NOT bring across the queries and workbooks. It's been our experience that SAP's business content queries are inappropriate for most businesses unless you've implemented an ASAP or standard business process. I would simply set the SAP stuff aside and focus on the data model. The HR data model with its time dependent master data can be a serious pain in the posterior.
However... you should be able to open the BW 1.2 queri in the Bex 3.x Query Designer, rather than Bex Analyzer. If that does not work, there were upgrade tools prior to that, but it's been so many years I don't recall them.....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.