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