GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  BO Designer
Go To First  |  Previous Question  |  Next Question 
 BO Designer  |  Question 70 of 116    Print  
How to create Universe using Flat file in BO6.0

  
Total Answers and Comments: 3 Last Update: June 15, 2006     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


 
Go To Top


 Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape