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: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

Add derived table to dfx from different database


 
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
frank35
Principal Member
Principal Member



Joined: 25 Aug 2005

Posts: 401
Location: London


flag
PostPosted: Thu Sep 05, 2019 9:37 am 
Post subject: Add derived table to dfx from different database

I am trying to add a derived table into a dfx. Universe is currently single-source however the database I am creating the derived table from is listed as it's on the same server. Is this possible? Currently all other tables are on a different database on that server. Thanks.

BOE 4.2 SP7
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6633
Location: Connecticut, USA


flag
PostPosted: Fri Sep 06, 2019 10:22 am 
Post subject: Re: Add derived table to dfx from different database

Which RDBMS? The only thing that matters here is whether the ID that you're connecting to the database with has permission to execute the SQL contained in the DT. If so, then you should have no problem creating the derived table.
Back to top
ABILtd
Forum Enthusiast
Forum Enthusiast



Joined: 08 Feb 2006
ASUG Icon
Posts: 1889


flag
PostPosted: Fri Sep 13, 2019 5:18 am 
Post subject: Re: Add derived table to dfx from different database

I agree, with SQL Server for example you can qualify a table reference right down to the database.

Oracle doesn`t use the database concept, so would be ok with the right schema access.

So depends on the DB backend.

_________________
BI and Analytics Presales Consultant
------------------------------------------------------
BOXI R1, R2, R3, R3.1, R4.1, R4.2, CE 8, 8.5, 9, 10, SAP Analytics Cloud, Crystal Reports, Lumira, PowerBI, Tableau, JasperServer, iReport, LogiAnalytics, BIRST, Qlikview, Xcelcius, Netezza, T-SQL, PLSQL, DTS, SSIS, BODI, BODS, Kimble etc....
------------------------------------------------------
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.0279 seconds using 17 queries. (SQL 0.0027 Parse 0.0008 Other 0.0243)
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