Page 1 of 1

View in cube does not exist error

Posted: Thu May 13, 2021 9:29 am
by vasek1192
Hi, I am attempting to run simple TI process with ViewTitleElementSet. I created the view Default as seen in the pic, but when i try to run it I get an error msg: Error: Prolog procedure line (26): View "Default" in cube "<2>" not found. When I swith to Default1 it works fine. Any ide what might be causing this? Thanks
Dault Does not exist.png
Dault Does not exist.png (55.98 KiB) Viewed 8162 times

Re: View in cube does not exist error

Posted: Thu May 13, 2021 10:06 am
by Wim Gielis
You can open up the view manually without issue ?
What is the result of the ViewExists function on that cube and view ? 1 ?

Re: View in cube does not exist error

Posted: Thu May 13, 2021 10:44 am
by vasek1192
Hi, Yes I can open it, ViewExists returns 1

Re: View in cube does not exist error

Posted: Thu May 13, 2021 10:52 am
by Wim Gielis
Could security be involved and does it work when you run with an admin user ?
What is the layout of the view ?
Does the code work in the Prolog tab of a new process ? Why is the code sitting in the Data tab anyway: what is the data source and what happens in the Prolog tab ?

Re: View in cube does not exist error

Posted: Thu May 13, 2021 11:25 am
by vasek1192
Thore is a cell security (see emg), I am an admin and cant run it. The layout is 7 dimensions:

G_Dcerinne_Spolecnosti on Rows,
T_CasM - Columns
G_Druhy_Vozu
G_Temata
G_Zavod
V_Verze
M_Dcerine_SPolecnosti_Zasoby_IST

There are 3 dynamic subsets: G_Dcerinne_Spolecnosti, T_CasM, V_Verze
sec.png
sec.png (91.59 KiB) Viewed 8148 times

Re: View in cube does not exist error

Posted: Thu May 13, 2021 12:01 pm
by Wim Gielis
Does it persist after a server reboot ?

Re: View in cube does not exist error

Posted: Thu May 13, 2021 3:33 pm
by gtonkin
Random thought but have you tested if you have two dimensions on the rows in your default view then try move V_Verze to the Titles?
PAW explorations do not show data if you do not have dimensions on either rows or columns - may be similar.

Re: View in cube does not exist error

Posted: Tue May 18, 2021 9:43 am
by vasek1192
Problem solved. It is somewhat of a bug in PAW. Turns out if you manually create view in PAW (open the cube, manually change the dimension structure and save to the server) then the view is invisible for some functions and it is not even visible in architect. If you create the view with process or in architect it works fine.

Re: View in cube does not exist error

Posted: Tue May 18, 2021 10:52 am
by David Usherwood
I recall that views created in PAW are MDX views (extension .xbv) and these are not visible in Perspectives/Architect.