Problem with write back

Question

Problem with write back

Allan Serrano

SSC Rookie

Points: 26
More actions
August 14, 2007 at 12:27 pm

#174285

Hi, I need to use the write back function. I am using a cube in SQL Server 2005.
I try with a lot of things but not work.

Please can someone help me

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Dave Balsillie SSCertifiable Points: 5589 More actions · Answer 1

You haven't said what you're trying to do, or what errors you're seeing, so it's difficult to make suggestions.

In general, carefully consider why you're using write backs. Often, it's much better to persist the information back to a table, then process the information back into the cube. That way, you're guarrenteed you're not going to lose the data. Some general design principals:

- Often, write backs are used to capture low volume data, such as high level budget or target values. In this case, consider designing a separate cube (or measure group). I'd recommend the separate cube (for security features) at the expense of some flexibility.

- using one of these approaches, you can process the data incrementally, often online as updates occur.

- I recommend as well you implement audit standards into the tables (some you can't do with write backs) to track who's making the changes and when. Otherwise, you might spend as much time trying to figure out what's happened to your data.

If this isn't on point, let me know.

skitter Valued Member Points: 59 More actions · Answer 2

Did you verify that you are using the enterprise version of SQL Server 2005 ?

Full Writeback Support is only available in this version and not in the smaller versions of SQL Server 2005.

(Source : http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx)

Allan Serrano SSC Rookie Points: 26 More actions · Answer 3

Ok thanks for the help.

I solve the problem, I am using a XL Cube program to do the write back.

sabarichandru SSCommitted Points: 1704 More actions · Answer 4

Hi,

I saw your post that you found the solution for the WriteBack to Cube from XL.

But i like to know if you share the steps u follow to resolve the issues . because past 2 days i'm crushing my head to resolve the issues. please share what level of coding you written in XL to update the changes to the cube.

It's very urgent for me .

Thanks in Advance!

Sabarinathan