on 2016 Nov 08 9:45 PM
Hi,
Here's my scenario:
1. I have created a simple calculated view in HANA Studio connected to my S4 environment;
2. I've exposed the calculated view as an External View, so I can consume it in the app layer of that S4 system. So I see that as an SE11 object now;
3. Using that external view, I have created a CDS View in the ABAP perspective in HANA Studio. It is working fine, and I can also see it as an object in SE11.
4. As per all the documentation I've read and I quote "Its Worth Noting that all S/4HANA CDS views are automatically exposed as a ODP transient Info Provider/Bex Queries"
5. I go to tcode rsrts_odp_dis to view the ODP Transient Provider that should be created for the CDS view, and I see that it exists
And when I execute I get a message:
And when I check the ODP I get an error message:
Am I missing any steps in order to create the ODP Transient Provider from the CDS View?
Thank you in advance.
Marcelo
Request clarification before answering.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marcus,
My solution was almost the same as yours. I simply added the @DefaulyAggregation: #SUM annotation and that made the field show up in the key figure value.
But curiously enough, the reason I was getting the error above in Analysis for OLAP had to do with the technical name of my CDS View. After I renamed it to something slightly smaller, it worked.
Why oh why couldn't SAP provide an error message that made more sense 🙂
Thank you all for your feedback!
Marcelo
Hi Marcelo,
you can also check the following links:
https://launchpad.support.sap.com/#/notes/2600268
https://wiki.scn.sap.com/wiki/display/BI/Default+Aggregation+in+CDS
Best Regards,Daniel
Hello Marcelo,
What are the version and the service pack of your ABAP component?
,Hello Marcelo,
What are the version and the service pack of your ABAP component? Are you developing on 740?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Marcelo.
If you are still facing the problem :
Trying adding a measure to your cube via your DDL source code.
A counter for example. I'm pretty sure it's what is missing.
Let us know.
Sebastien
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
58 | |
10 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.