How to set Custom Analytical Query as App Tile and can be accessed by other users

[marvintulagan]

Hi All,

I have a requirement to publish certain custom analytical queries in the S/4 HANA Cloud and should be accessed by other users as well. I have tried to save the query as a tile and assigned it to a specific group e.g. Communication Arrangement but other users only see it as "Test" and redirects them to Google website.

I have followed this blog (https://blogs.sap.com/2017/05/31/custom-analytical-query-how-to-create-a-custom-analytical-query-and...) through the creation of the custom analytical queries. A person has already asked this there but has yet to be answered.

These are my questions as well:

1. How to publish the Tile so that other users could access to it?
2. The tile in ‘My Home’ immediately jumping into the results before the ‘Prompt’ screen is opened for parameter selection. How do we go about it?

Best regards,

Marvin Tulagan

[marvintulagan]

Hi All,

Please ignore the error about redirecting to Google Website. It was a different app.

But anyway, I would still like to know how it can be exposed as an application.

1. How to publish the Tile so that other users could access to it?
2. The tile in ‘My Home’ immediately jumping into the results before the ‘Prompt’ screen is opened for parameter selection. How do we go about it?

[former_member614876 · Accepted solution]

Hi Marvin,

Try to create a query, and then copy the query name, go to a new catalog, create a static tile and disable the Semantic object navigation, and instead, in the Target URL field, provide the url in the following format:

#AnalyticQuery-analyze?XQUERY=2C<SQL Name of CDS>/<query name>

Save the tile, assign it to a Group in the designer, and then share to the other users.

Thank you

[a_domurath · Accepted solution]

Hi Gagan,

how would you configure the respective target mapping in this case?

Thanks in advance

Alex

[marvintulagan]

Hi,

Any help would be appreciated.

I was also not able to create it in the View Browser since there were no views displayed.

Thank you in advance!

[Alexia]

I know it's years later, but I will leave a possible answer in case someone might find it useful.

Usually when a custom view is not available in a Fiori app, it's because the view is not released with contract C1(for internal use). This can be changed with Eclipse.

[marvintulagan]

Hi All,

I have also tried by creating an application in the View Browser but to no avail was still unable to create a tile.

I encountered another issue - no views were displayed in the View Browser even though I have the BR_EMPLOYEE and BR_ADMINISTRATOR authorizations.