BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Repointing Aliased tables to other tables


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
TurningPointHolland
Principal Member
Principal Member



Joined: 06 Sep 2006

Posts: 357
Location: Gorinchem, Holland


flag
PostPosted: Tue Jun 11, 2019 10:40 am 
Post subject: Repointing Aliased tables to other tables

I am struggling in Information Design Tool 4.2 to get an easy job done but cannot believe this is not possible.

I have 7 Oracle tables which I all have aliased. The tables are in Oracle scheme X.

Some things have changed in Oracle. We now have those 7 tables in database scheme Y.

I imported the 7 tables again. As a last step I want the Aliases I already had to point to the 7 new tables. This is where I got stuck!

I tried to find where I can tell those aliases to look at another table. I remember this was very easy in Designer / Universe Design Tool icon_smile.gif The reason to make an alias in the past was just having the ability to change to another table without rebuilding joins, contexts an objects....

Anyone a solution?

_________________
Ton Vermeij
Senior SAP BI, Lumira, PowerBI, Tableau and Alteryx Consultant
Gorinchem, Holland, Europe
Owner of www.theturningpoint.nl and co-founder of
www.bi-united.nl (dutch BI-freelancers network)
Back to top
buzz
Principal Member
Principal Member



Joined: 11 Aug 2005

Posts: 188
Location: Sydney


flag
PostPosted: Wed Jun 12, 2019 8:15 pm 
Post subject: Re: Repointing Aliased tables to other tables

In Data Foundation select the Aliased table. Depending on your layout you may need to unhide the Properties pane (by default is at bottom of screen)
From here you will see the Original Table name with a button to bring up list of all tables so that you can change the base table for the alias
Back to top
TurningPointHolland
Principal Member
Principal Member



Joined: 06 Sep 2006

Posts: 357
Location: Gorinchem, Holland


flag
PostPosted: Thu Jun 13, 2019 2:03 am 
Post subject: Re: Repointing Aliased tables to other tables

Hi Buzz,

Thanks very much! I hide that pane by default. But is it there! Finally!

icon_lol.gif icon_wink.gif

_________________
Ton Vermeij
Senior SAP BI, Lumira, PowerBI, Tableau and Alteryx Consultant
Gorinchem, Holland, Europe
Owner of www.theturningpoint.nl and co-founder of
www.bi-united.nl (dutch BI-freelancers network)
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0266 seconds using 17 queries. (SQL 0.0024 Parse 0.0008 Other 0.0234)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo