Can't find view recently created?

building semantic layer
1

Hopefully this is an easy question. I had a new view created (in Oracle) when I try and rename the table that it is a view of in designer it doesn’t exist. When I look at my list of tables it is not there. When I look using SQL it is there. Are there any ideas why it isn’t showing up in designer?

Thanks,
Chad

Listserv Archives (BOB member since 2002-06-25)

2

I had a new view created (in Oracle)
when I try and rename the table that it is a view of in designer it doesn’t exist.

Make sure it’s not a synonym. My DBAs have made synonyms rather than views and those cannot be seen in Designer.

Listserv Archives (BOB member since 2002-06-25)

3

Chad,

Make sure that the oracle view you created was PRIVATE and not public. Business Objects uses the Database dictionary to determine whether or not the view, table or synonym will appear in the Designer Module, but it uses only those tables that are private.

Just make sure that when your object is created, you avoid the use of the PUBLIC option. (and also create the object in the appropriate account).

Thanks!
-rm

From: Chad Johnson cjohnson@ONEXINC.COM Hopefully this is an easy question. I had a new view created (in Oracle) when I try and rename the table that it is a view of in designer it doesn’t exist. When I look at my list of tables it is not there. When I look using SQL it is there. Are there any ideas why it isn’t showing up in designer?

Thanks,
Chad

Listserv Archives (BOB member since 2002-06-25)

4

Did you read what the other guy said. It sounded like he was saying that you CAN see a synonym as long as it’s not public. I didn’t know that. Need to test it…

Listserv Archives (BOB member since 2002-06-25)

5

Sorry all. I sent this to the list by mistake. Had I sent it to the list intentionally I would have more politely replied :slight_smile: …

Robert added that “whether or not
the view, table or synonym will appear in the Designer Module, but it uses only those tables that are private.”

I didn’t know that a synonym could be available to a designer.

Thanks Robert!

:slight_smile:

Cindy

Listserv Archives (BOB member since 2002-06-25)