Review Booklet Designer Add More Analytical Queries

[Mert1998]

Hello Everyone,

I wanted to expand the Review Booklet by adding my own queries. Unfortunately, when creating the Business Page and the Page, the following error is displayed. Even though I have made all the settings in Custom Analytical Queries and Services. 

In addition, I have also defined all fields as shown in the image above.

Does anyone know what could be causing the error?

regards,

Mert

[OwenLiu]

Hi Mert, May I know which exact app do you mean?

[HenrikeGrötecke]

Hello Mert, Thank you for your question. Unfortunately, I can't see any images. Can you please add the error message? Thanks! I suppose you're aware of the SAP Help Portal documentation under https://help.sap.com/docs/SAP_S4HANA_CLOUD/a630d57fc5004c6383e7a81efee7a8bb/2acb23f7cabc472a8aec1988...?

[HenrikeGrötecke]

Hello,
I'm closing this question as the attempt to clarify the question wasn't successful.
Should the issue persist, please raise another question that includes the error message in writing or in an attached image.
Thanks for your understanding.
Kind regards,
Henrike

[Mert1998]

Hello everyone,

the error was that I did not add any filters to the variables in the Custom Analytical Query and Services. In addition, some variables have to be created as parameters.

King regards

Mert Bektas

[HenrikeGrötecke · Accepted solution]

Hello Mert,
Thank you for your question. Unfortunately, I can't see any images. Can you please add the error message? Thanks! I suppose you're aware of the SAP Help Portal documentation under https://help.sap.com/docs/SAP_S4HANA_CLOUD/a630d57fc5004c6383e7a81efee7a8bb/2acb23f7cabc472a8aec1988...?

Kind regards,

Henrike

[Mert1998 · Accepted solution]

Hello Henrike,

I am getting 14 errors. The errors are CDS view field P_FiscalPeriod is not valid as booklet variable, although I have it in the field selection in the query (App: Custom Analytical Queries and Services). When I click on Show Error, it goes to the Variables tab and shows me the CDS fields in red at Booklet Leveland also says that I should reset the variables.

King Regard Mert

[HenrikeGrötecke · Accepted solution]

Thanks for your question. It has been forwarded to the experts.