Unable to activate Dynamic Caching for a Calculation view

[former_member389878]

Dear Experts,

I Have been working to improve my query performance with the help of Dynamic caching mechanism. I doing an exercise on the same.

However, When I try to activate my dynamic caching option with this command

CREATE VIEW ***

AS (SELECT * FROM ******)

WITH DYNAMIC CACHE;

However, I'm getting this error

Feature Not supported : Cannot Add result cache on this view : The semantic of a view is not suitable for dynamic result cache ( Only Column tables are cache able)

Note : I have created a Graphical calculation view of type Cube with the default node as Aggregation and have used a single Column table inside the view and then creating a SQL view with the help of above command (Because Dynamic Caching works only for SQL view and not graphical view).

I'm unable to understand what is wrong. Could you please help

[former_member306772 · Accepted solution]

Hi,

If you are trying to create a SQL view on top of a graphical calc view (create view <view_name> as select <col_list> from <calc_view> with dynamic cache), it's not supported.

Creating a dynamic cached view is only possible if you use a column table in the projection clause of the view definition. And it also should include a group by clause!

Your syntax should look like below:

create view <view_name> as (select <col_list> from <column_table> group by <col_list> with dynamic cache)

For additional information, you can visit - https://help.sap.com/viewer/bed8c14f9f024763b0777aa72b5436f6/2.0.04/en-US/a5afa24b477e4e2a8d6d8f9888...

[former_member389878 · Accepted solution]

Hi Hari,

Yes I was trying to create a SQL view on top of a Graphical view. and As you said, This feature is not supported.

Thanks a lot.