topic Re: View defined but not seen in EG 4.2 or Management Console in Developers

View defined but not seen in EG 4.2 or Management Console

metalray — Mon, 14 Feb 2011 10:52:10 GMT

Hello,
I have created a view and can select from it as well but somehow it does not show up as an object when I use EG4.2 or the Management Console.

create view Test_BASE.WORK_myway as select * from WORK.myway;

select * from Test_BASE.WORK_myway;

--result is displayed

Re: View defined but not seen in EG 4.2 or Management Console

twocanbazza — Mon, 14 Feb 2011 19:11:07 GMT

Have you defined it in the Metadata?

Re: View defined but not seen in EG 4.2 or Management Console

metalray — Tue, 15 Feb 2011 11:39:29 GMT

Hello twocanbazza,
A good question and that was/is indeed the problem. I am unable to register a VIEW based on a WORK table in the metadata.
1. If I use EG 4.2 via Tools -> Update Library Metadata I get the error
"No metadata objects found matching the specified URI".
Odly, one of the three Views is registered and ready to use. (strange)

2. If I use SAS OLAP Cube Studio -> Register tables and select the tables
that are part of the library, I get the error "WORK.MygreatView.DATA does not exists."
The table is then registered without any variables or data.

Note, this all works fine if I register VIEWS that do --not-- select from the WORK library but as soon as the view select from the WORK library the whole thing causes problems.

Why I use the WORK library? - I want to create prompt source tables that are filled depending on the user login (dynamic PROC SQL - identity driver properties) by a STP that executes as soon as the web report opens.

Re: View defined but not seen in EG 4.2 or Management Console

metalray — Tue, 15 Feb 2011 16:14:53 GMT

I managed to register the tables in metadata with the following code:

proc metalib;
omr (library="Amylib");
select(View1);
report;
run;

(the code generated by EG 4.2 is missing the SELECT line).