Analytics and Report Gallery in Hybris Marketing on premise

[sinaei]

Dear All,

In the version of 1708 of on premise we have "Analytics and Report Gallery"

Does anyone know how can we customize the query and views?

For example we want to create a new Report and want to add sales data (like Number of Quantity) as a measure.
In none of the existance reports we have this kind of data...
And also we have just data for "Contacts and Profile" section, for the others it is saying "No Data to display"

Does any one know if and how we can achieve this?

Thanks
Sepide

[isathore]

Hi,

Do you have access to the Early Knowledge Transfer? If not, you can refer to this document for getting access. It provides a wide range of information and training that could be useful.

On-premise, you can use ABAP in Eclipse to create CDS views. There are a few blogs and documentation about it

https://blogs.sap.com/2017/09/09/abap-core-data-services-introduction-abap-cds-view/

https://www.sap.com/canada/developer/tutorials/abap-dev-adt-create-cds-view.html

There also this one highlighting some differences between on-premise and cloud

https://blogs.sap.com/2017/12/21/sap-s4hana-extensibility-custom-cds-views-in-sap-s4hana-cloud/ however, the main discussion is around how to create it in the cloud version.

I hope this helps

Isabelle

[isathore]

Hi,

As a start, may I suggest that you check our Analytics and Reporting 1709 guide

https://help.sap.com/viewer/6a81c7209a0e485aabe3476dcd6a1641/1708%20YMKT/en-US/c259aac2c2b446baa7b5c...

Best Regards

Isabelle

[sinaei]

Hi Isabella,

Thanks for your help,

But actually I am looking for the way to create my custom CDS

Is it possible? I do not know how can I create it

Thanks
Sepide

[SauMaris]

SAP Analytics Cloud license is needed even to consider it, right?

Maris

[isathore]

Hi Sepide and Caro,

CDS views are not shown in the Analytics and Report Gallery, unless there are analytical queries.

To create custom operational reports in Cloud, refer to our online documentation:

https://help.sap.com/viewer/0f9408e4921e4ba3bb4a7a1f75f837a7/2008.500/en-US/adb0454cbee247a68cfcd820...

https://help.sap.com/viewer/b88f770e4b7c4ecead5477e7a6c7b8f7/2008.500/en-US/a046702650254b589d15ee8c...

To create custom operational reports on-premise, refer to our online documentation:

https://help.sap.com/viewer/0204678aad934e5da0ecf4d40ba38ca9/2020.YMKT/en-US/a046702650254b589d15ee8... under section Infor Area Assignment.

In both cases, you need to create analytical queries

Best Regards

Isabelle

[sinaei]

Hi Isabella,

Thank you so much for your help, and sorry for my late response.
I was in the phase of creating custom CDS view

I have created a custom calculation view and then Exposed it to HANA the created the custom CDS for my custom External view.

But how can I see it in the analytic view?

Could you please help me?

Thanks
Sepide

[former_member600860]

Hi Sepide,

Did you get any further at this point then?

Do you know how you can make a custom analytical query visible for the enduser in the Analytics and Reporting App?

BR

Caro

[isathore]

Hello,

2 things:

- You don't need a license for SAC to create custom CDS. CDS can be used for different purposes and tools than in SAC.

- You need a license for building and viewing analytical stories in SAC. However, you should check the customer contract to undertands which licenses are part of the agreement or not. The account executive shall be able to help you in this regards.

Best Regards

Isabelle