Business Objects - How do I synchronise Microcubes generated by different queries?

GeekInterview.com > Interview Questions > Data Warehousing > Business Objects

Go To First | Previous Question | Next Question

Business Objects | Question 187 of 239

How do I synchronise Microcubes generated by different queries?

Total Answers and Comments: 6

Last Update: February 26, 2008 Asked by: jiggley67

Sponsored Links

Best Rated Answer

—

Submitted by: sreya_1234

Microcube is the one which stores the results of the query.
each data provider stores it results as/ in the microcube when we create the query in the query panel.
you can access the micro cube in the BO (reporter) -> Data -> view data.
and synchonize 2 different data providers (micro cubes) with common dimensions.

Above answer was rated as good by the following members:
pavan4reddy, anuanu

October 25, 2007 06:37:13

nishamakhija21

Member Since: October 2007 Contribution: 9

RE: How do I synchronise Microcubes generated by diffe...

Microcubes are Synchronized by linking the different data provider through dimension object in the report.

Is this answer useful? Yes | No

January 20, 2008 13:05:35

bolladi

Member Since: January 2008 Contribution: 6

RE: How do I synchronise Microcubes generated by different queries?

Could anyone please tell me , whats a microcube and how can we access a micro cube....

I thought micro cube is a structure where the result of the query is stored before the report is being created.. , so is it possible to access those micro cubes..

Is this answer useful? Yes | No

January 30, 2008 19:38:58

sreya_1234

Member Since: November 2007 Contribution: 15

RE: How do I synchronise Microcubes generated by different queries?

Microcube is the one which stores the results of the query.
each data provider stores it results as/ in the microcube when we create the query in the query panel.
you can access the micro cube in the BO (reporter) -> Data -> view data.
and synchonize 2 different data providers (micro cubes) with common dimensions.

Is this answer useful? Yes | No

2 0

Overall Rating: +2

February 20, 2008 13:21:35

Girish Sabbi

Member Since: February 2008 Contribution: 3

RE: How do I synchronise Microcubes generated by different queries?

Microcubes store data which is fetched from the Database as it is. This data can be exported to your local file, by clicking the Export option.

Is this answer useful? Yes | No

February 22, 2008 22:29:50

vams_gk

Member Since: July 2007 Contribution: 4

RE: How do I synchronise Microcubes generated by different queries?

micro cube is not a report or tool.it is structure located internally.when u run a query in DI or WI fiirst time,retrive the data from the database.when u run the same query once again the data can be attach with microcube.data retrival is fast.beacause every time retrive data from the database is a long process.

finaaly data retrival is very fast.u can fine when u run the big quiries

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 26, 2008 21:11:09

manikandans25

Member Since: February 2008 Contribution: 3

RE: How do I synchronise Microcubes generated by different queries?

Microcube is a dataset derived and it locally stored after refresh if it is a thick client and in server repository if it is a thick client.

In order to synchronize microcube from two data provider, just join the common dimensions from two microcubes .

Is this answer useful? Yes | No

Go To Top