direct data access

[Former Member]

hi..

In wat cases do we go for Direct Data Access??

detail description will be heavily appreciated

regards

madhuri

[Former Member]

Hi,

Direct data access is needed for Virtual providers. Virtual providers are needed usually for following purpose:

You have a multiprovider which has a base cube and virtual cube.

You are loading data regularly to base cube, lets say you have scheduled data load in the midnight. But you run your query in the morninng, in this scenario you will loose data from midnight to morning if you use only base cube. So, to overcome this it is god practice to use virtula provider which will get real time data (in this case data from midnight to morning).

So, virtual providers are used only when you require realtime reporting, something like if you want to analyse data for last 24 hrs, 48 hrs, then you could use virtual providers.

For virtual providers to fetch data from source system directly, you need to enable 'Direct Access' for virtul providers. This you can do by selecting the source system using the option 'Activate Direct Access' when you right click on Virtula providers. Virtual providers are like any other infoproviders, so you have to create query on them as you do on other data targets.

Hope this helps.

Best Regards,

Rajani