Retrieve DATA of the DATABASE in the BPC for Excel VBA

[Former Member]

Hello I am trying to do a check in VBA in Excel to BPC, but for verification must be correct to check if the value in the report came from the bank or typed (input).

How can I do this?

For example

I have the following worksheet

*A                 |              B              |          C* 

                                  10

The data in column "B" came from the bank, in which case I can not change - it

I can only enter data in columns "A" and "C"

Help me!!!

Edited by: andreia.lopes on Aug 27, 2010 12:21 AM

[Former Member]

Could not make that determination

[sorin_radulescu]

Any BPC users does not have direct access to database.

In your case you have to create different data source for your input. In this way you will know for each value from where is coming looking to data source.

If you are doing insert for the same data source especially after full optimize we will not be able to get the information from where is coming.

For this reason you have to design your application from beginning to create members into data source dimension for each possible source of input.

I hope this it will help you.

Regards

Sorin Radulescu

[Former Member]

Hi,

How do I check the value of the report came from the database or typed??

I'm using EVDRE

[Former Member]

Hi,

I didnt understand the question correctly.

Do you want to know the source of the data? Or do you want to fetch the data from the database based on their source?

Can you please provide some more information on your requirement?