TM1 Forum

Has anybody tried using writeback through DBRW formulae in CAFE? We think it doesn't work and IBM's documentation is not explicit about whether writeback is supported.

Not sure why you'd want to use DBRW when you can just write in to a Cell & load it to the cube as far as I'm aware, no need for specific formulas to do so.
Your uncommited cell will turn blue, you can then commit from one of the buttons on the top left.

David Usherwood wrote:Has anybody tried using writeback through DBRW formulae in CAFE? We think it doesn't work and IBM's documentation is not explicit about whether writeback is supported.

No, it doesn't support Write Back (yet). The moment you type in any numbers, it will wipe out any DBR/DBRW/DBRA formula.

RJ! wrote:Not sure why you'd want to use DBRW when you can just write in to a Cell & load it to the cube as far as I'm aware, no need for specific formulas to do so.
Your uncommited cell will turn blue, you can then commit from one of the buttons on the top left.

It makes sense IMHO. Basically CAFE translate DBRW into the CAFE call and make it feasible to deploy Excel slices based on DB formula on WAN connection. To me this is a good approach but there are more works to be done.

I meant that you would do the "Slicing" (a.k.a. crosstab) via CAFE and you are then able to update any numbers that you have in your crosstab directly in the cell.
Or you could develop your Templates with the required views in a crosstab for the User to do what ever updates need to be done.

Again, if you have CAFE, not sure what the benefit of a DBRW formula is?
I can see they are good for DBRA & the like though

RJ!

Not everything you send to TM1 is input from the user. There are many cases where you just want to send some data back based on calculations or perhaps update several cubes based on input data, and other such things. I get CAFE trying to speed up performance by making things query based, but not having a way to update other cube data based on background calculations is an issue.

This is a delicate balance between flexibility and performance.

I am developing some reports in CAFE using TM1 cube.
I have a similar question about DBRW() function . I have used the function in CAFE report . I am not getting any error messages,but I am not getting data.

Here are some steps below,what I have done so far.

1. I have created a report in Exploration mode.
2. Converted exploration mode to Flex view.
3. In Flex view ,we have filter selections are there . Instead of that I have used SUBNM() TM1 function for drop down selection list which is working fine.
4. User needs a Dynamic year selection so I have retrieved the year,using
DBRA() function from one of the dimension.
5. I am doing cell based calculation to get the values of that intesection point using DBRW() function.
6. Everything is fine .. no errors .. no issues . but I am not getting data.
7.With the same concept we have build the TM1 websheet in perspectives.It is working fine and getting data.
8.But with the CAFE ,I am not getting data.

If you have any ideas,please pass on it please . I appreciate all your help.

VJD,

Make sure that CognosOfficeTM1.xll addin is active in Excel. You may need to activate it manually. The file can be found in installation directory.

Hi,

I have activated manually TM1 as you said ,but then also .I am not getting data.

Thanks gor the repky.

Are any of your formulas working in CAFE?

Do you have CAFE & Perspectives running at the same time?

Have you had any errors relating "restarting Excel" before TM1 formulas can be used?

Have you registered CAFE properly on your Machine? (you need Admin access)
Go to “HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\Addins”
You should see something like below:
"Description"="IBM Cognos Office for Excel 2007/2010"
"FriendlyName"="IBM Cognos Office for Excel 2007/2010"
"LoadBehavior"=dword:00000003