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

[Former Member]

Hi Madhuri,

Direct Access means no persistent storage on the BI side.

Via VirtualProviders we can find a way to integrate data into anlaytical services by direct access. A DataSource for Direct Access will not provide a PSA table as we do not want to store data persistently. Nothing is different from the transformation point of view. We work with the special type of Cube – the VirtualProvider, and we use a special type of DTP for this Direct Access scenario.

For further info refer...

/community [original link is broken] threadID=424244&messageID=3516493#3516493

Creating Data Transfer Processes for Direct Access

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/fb8ed8481e1a61e10000000a422035/content.htm

Assign points if this helps.

Regards,

Anil

[Former Member]

First of all, the data source should support direct access.

Now your question:

If the data is so critical to the users and they need to view real tim data ; data as business happens.

Examples:

1. You are reporting on consolidated Financial data at the month end and year end and your CFO and CEO wish to view the final result at any time.

2.. you are dealing with goods and services the orders for which are worth several millions.

3. You are runing a promotion campaign and you wish to see the resuts as and when you want so that you can consider realining the promotion strategies.

Ravi Thothadri