How do I synchronise Microcubes generated by different queries?

Questions by jiggley67

Showing Answers 1 - 24 of 24 Answers

bolladi

  • Jan 20th, 2008
 



    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.. 

  Was this answer useful?  Yes

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.

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.

  Was this answer useful?  Yes

vams_gk

  • Feb 22nd, 2008
 

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

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 .

  Was this answer useful?  Yes

suresh

  • Feb 29th, 2012
 

Micro cube is the one which stores the results of the query.
each data provider stores it results as/ in the micro cube when we create the query in the query panel.

you can access the micro cube in the BO (reporter) -> Data -> view data and synchronize 2 different data providers (micro cubes) with common dimensions.

  Was this answer useful?  Yes

lionskashif

  • Aug 28th, 2012
 

When Query fired very first time it hits directly against the Database and then its fetch all data and store into one MICROCUBE. MicroCube basically a temp place holder where all the Possible dimension combinations is stored. So, whenever you drag and drop any dimension to report then it will fetch data through the Microcube unless you add any new dimension in the query.

Cheers.... Lionskashif

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions