GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  BO Designer
Go To First  |  Previous Question  |  Next Question 
 BO Designer  |  Question 70 of 117    Print  
How to create Universe using Flat file in BO6.0

  
Total Answers and Comments: 4 Last Update: March 13, 2009     Asked by: Adi 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 12, 2006 02:40:10   #1  
pat.mclean Member Since: April 2006   Contribution: 52    

RE: How to create Universe using Flat file in BO6.0

Business Objects deals with databases for every universe you need to specify a database connection. flat files dont have the database format so you'll need to convert them into some database. to do that you will need to write a procedure which will read data from flat files & relate it according to surrogate keys then using that procedure populate the database & then use that database for the source of the universe.

using flat files ONLY you can not create universe. because there is nothing as database connection available for flat file.

hope this solves your problem.

cheers

Pat.


 
Is this answer useful? Yes | No
June 12, 2006 08:26:15   #2  
pat.mclean Member Since: April 2006   Contribution: 52    

RE: How to create Universe using Flat file in BO6.0

Just one addition

if you are using only 1 flat file you can create a ODBC connection & in File DNS define ODBC Text Connection. this connection can be used for an universe to be created using flat file.

creating a universe for just a single flat file as per my knowledge & experience doesn't make sense. because you will need different dimensions fact tables & creation of which from single file is very tedious job. Apart from that Analytical reports are used for aggregated OLAP data that is huge in amount & 1 text or cvs file containing this data sounds practically imposible.

if you want to use that file for reports you can simply call it in BO Reporter when you are defining Data Provider & use it's data.

hope i have not created lot of ambiguity.

Cheers

Pat.


 
Is this answer useful? Yes | No
June 15, 2006 02:48:24   #3  
chennu        

how many fact & dimensional tables (max&min) ?
hi..... how many fact & dimensional tables (max&min)can use in projects?
 
Is this answer useful? Yes | No
March 13, 2009 00:44:25   #4  
sekharregati Member Since: March 2009   Contribution: 1    

RE: How to create Universe using Flat file in BO6.0
Of course we can create Universe from flat file by using EXTERNAL STRATEGIES
By using external strategies we are going to pull the meta data from flatfile and create the universe.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape