1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

Suppose we had a scenerio like in an universe there are
nearly 250 objects but only 50 objects data is updated
frequently so is there any way to overcome it.(Birla Soft,)

Question Posted / gani

Answers were Sorted based on User's Feedback



Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects dat..

Answer / alka

I think this question requires more clarifiaction. Because
as far my understanding goes, Universe is just a symantic
layer between report and database. It is holding schema
details and not data. If objects are unwanted then they can
be hidden. The extra 200 objects will just hold the space
in BO repository like joins,table names,etc. Any comments
on this welcome. CHEERS,ALKA

Is This Answer Correct ?    9 Yes 2 No

Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects dat..

Answer / vidhya

Create a view for only those 50 objects and load into
universe,connect this view with some table.

Reason: When you update the base table the view will be
automatically updated for those 50 objects.

Advantage: Performance will be good as the refreshment of
universe is minimized.

Kindly let me know if i am wrong with correct reply.

Is This Answer Correct ?    4 Yes 5 No

Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects dat..

Answer / av

there is always a query behind a view which gets executed
while a view is queried. so creating a view doesn't help in
performance enhancing. best way is to create a table with
50 objects.

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More Business Objects Interview Questions

explain merge dimensions with real time in DWH?

1 Answers   IBM,

How do scheduling the report in BO XIR2? can you say what are they steps?

5 Answers  

I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?

2 Answers   Rolta,

HOW TO SPOT A HIERARCHY?

2 Answers   TCS,

1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?

4 Answers   KPIT, TCS,




How to create Index to the table in the universe designer and how it improves the Query performence

0 Answers  

How to import BIAR file in bo?

1 Answers   Emirates, Zensar,

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers  

what is local filter

2 Answers   Cap Gemini,

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

0 Answers  

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers   TCS,

BO Webi report in running fine in Dev but takes a long time to run in Production environment, how to reduce this processing time.

1 Answers   Infosys,

For more Business Objects Interview Questions Click Here
Categories