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.

Adding Custom Strategy for Table Structure in Universe


 
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
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Sat Aug 15, 1998 9:07 am 
Post subject: Adding Custom Strategy for Table Structure in Universe


ParameterWindow

One "trick" to getting the tables in the other instance to show up in the BusinessObjects structure window so you can create objects from these tables is to change the universe connection string. Of course, then, the tables in the first instance won't show up. If you perform an integrity check on universe, you will get errors. As long as the long term connect string has read access to all the tables, the user queries will run fine.

Best Regards, Lori
Lori_SAGE@solution4u.com
SAGE Solutions, Inc.
908-813-8207


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
Back to top
Listserv Archives
Archive Owner
Archive Owner



Joined: 25 Jun 2002

Posts: 24831



PostPosted: Fri Sep 18, 1998 4:24 am 
Post subject: Adding Custom Strategy for Table Structure in Universe


Parameter Window

Hello,

>I am not sure what the proper keyword is for 'TYPE'. I guessed 'STRUCTURE', 'TABLE' etc.

the proper keyword is 'STRUCT'.
the other two keywords for external strategies are 'OBJECT' and 'JOIN'.

You can find this information in the 'Designer Guide' on page 73.

It worked for us with a text file based table strategy.

In the file STSRVge.txt is the entry:

[STRATEGY]
TYPE=STRUCT
NAME=Table Strategy

[FILE]
NAME=C:\Programme\BusinessObjects\Odbc\tables.txt

[HELP]
HELP=Choose this strategy to import the table structure into Business Objects.

---

The referenced file tables.txt looks like this:

testdb businessobjects table1 column1 C Y testdb businessobjects table2 column1 C Y

---

hope this helps,

Patrick


_________________
AOL Listserv Archive Post
This message was originally posted on the BUSOB-L AOL Listserv. It was archived to this forum to maintain a historical listing of issues and solutions from 1998 to August 2002. More Details
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.0269 seconds using 17 queries. (SQL 0.0030 Parse 0.0008 Other 0.0230)
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