Excel Addin BSAVE Function

Karel Kpamegan

Hello,

 

I am looking for help on the new BSAVE function (Board 10.6) 

I didn't find recent documentation about Excel Office Addin.

 

Thanks,

Karel K.

Unknown

Hi,

For your 2nd example, you can use the function DBRW.

In this example, I have a matrix per year, result reporting account, sap account and profit centre. In the column New Value, you can set a new value for the existing combination and the function DBRW will save the new value into your cube.

I hope this will help.

best regards,

RJ

------------------------------
Robert-Jan van Kuppeveld
Smart Finance Consultant
Axians Laren
Netherlands
------------------------------
-------------------------------------------

Unknown

In the following screen you can see an example of BCUBE and the new BSAVE functions.

The database is called 'staffing anon', the cube is called 'leads'. Months on the columns, Industry on the Rows.

Using BSAVE, enter a new value in C10 and hit the Board Excel add-in refresh button and you will see that the green cell in the grid is updated with the new value that was entered in the cell - and the new value is written back to the Board database.

I hope this helps.

Karel Kpamegan

Hi Phil, 

Thanks to your eplainations I've tried to use BSAVE function at the base level of my cube, but it doesn't seems to work neither :

 

 

For your information I've made the 10.6 office addin upgrade last week : 

 

Regards,

Karel K.