cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Analytical Queries App: not able to create a new query successfully

Former Member
4,629

Hi,

Tried to create a query with custom analytical queries app in a S4H system (Version 1809).

And followed the link below

https://developers.sap.com/tutorials/abap-custom-analytical-queries.html

But found I can’t create it successfully.

After selecting the example view I_GLACCOUNTLINEITEMCUBE, no source view name was shown in following screen which asks for "Label" name.

And when jumped to the step of “Field Selection”, got an empty available fields list.

Looks like I can’t select the source CDS view properly.

However, I didn't get any error message like missing authorization during the creation process.

Also tried to create a new query with other kinds of views as source, like consumption views, views created with "Custom CDS view" app, got the same issue.

Searched SAP Notes, Knowledge Base Articles and community forum, no answer can be found so far.

In the link above, it mentions a role SAP_BCR_CA_ANA_AQD_PC to be assigned to users, but can't find in my system. Guess it's about a different S4H version.

However, I did assign SAP_BR_ANALYTICS_SPECIALIST to my user based on the Custom Analytical Queries Implementation Information from SAP https://fioriappslibrary.hana.ondemand.com/sap/fix/externalViewer/#/detail/Apps('F1572')/S13OP

Besides, all the other components mentioned there have been enabled:

The ICF nodes: ANA_QDESIGN_MAN, FIN_DS_ANALYZE

OData service: ANA_QUERY_DESIGNER

Technical catalog: SAP_BASIS_TCR_T

Business Catalog: SAP_CA_BC_ANA_AQD

Business Group: SAP_CA_BCG_ANA_AQD

Could you please give any help?

Thanks!

Regards,

Matt

View Entire Topic
hython
Explorer
0 Kudos

I have the same problem.

Even I input the Label for Custom Analytical Query, it will be cleared after enter.

no fields were displayed in the next page.

I am also using 1809 version of S/4.

I tried in two system, Just got the same result.

Former Member
0 Kudos

Hi Hui,

Did you already find a solution?

KR,