View in cube does not exist error

[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 (55.98 KiB) Viewed 8165 times

[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 ?

[vasek1192]

Hi, Yes I can open it, ViewExists returns 1

[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 ?

[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 (91.59 KiB) Viewed 8151 times

[Wim Gielis]

Does it persist after a server reboot ?

[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.

[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.

[David Usherwood]

I recall that views created in PAW are MDX views (extension .xbv) and these are not visible in Perspectives/Architect.