Hi All,

I am new to analysis service.

I am looking for ssas writeback option

Can any body please help me out how to write back to fact table in ssas?

Thanks & Regards,

Mahesh

 

Hi

 

You can use UPDATE CUBE.

You can do weighted allocations and even distributions.

 

You just need to enable writeback on the partition tab of your cube in VS. (right-click your partition and select 'write-back settings')

 

Here's something to get you started : http://msdn.microsoft.com/en-us/library/ms145568.aspx

 

Hi Jason,

Thanks for the reply.

I have already set the writeback option.

How should I use write back option so that modified data will be inserted/updated into relational database?

 

• Marked as answer by XLP - Main Thursday, January 13, 2011 1:19 PM
• Unmarked as answer by XLP - Main Thursday, January 13, 2011 1:19 PM

SSAS creates a table that contains all your writeback rows.

 

By default it's called Writeback_<MeasureGroup name>

You can writeback using the UPDATE CUBE statement or a client like Excel 2010 (Options-->Whatif Analysis).

This writeback table relates directly to the cube partition. Test it using Excel and see how it writes the values to the table.

 

If you want to write back to another relational table or set of tables you'll need to use another process from there - SSIS/SQL (triggers) from writeback table to whatever table you need to sort out.

 

Regards,

Jason

Partition WriteBack is used for updating cell data. Whenever you enable writeback option on partition & process cube,analysis services creats writeback table in the relational database which keeps the track of changes. Whenever you enable partition witeback,wizard asks for storagemode and name of writeback table.So if you are using SSAS 2008 then use MOLAP storagemode because the mdx query performance is good for MOLAP storagemode and whenever you update cube using MDX UPDATE CUBE statement,analysis services keeps the track of changes in writeback table (in RDB).
Refer following links for more details;
http://msdn.microsoft.com/en-us/library/ms174823.aspx
http://msdn.microsoft.com/en-us/library/ms175664(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms145568.aspx

Hi All,

Thanks for the suggestions.

I am confused here how I will achieve this. Can anybody guide me?

My requirement is
I am using JQuery grid. I want to bind cube data with JQuery grid.
When I will do any changes in the grid cell(add/modify) it will be write back to cube and finally on save button click I want it to save in the relational database.

Please guide me.

Thanks in advance.

Mahesh M.

Hi

 

You're on the wrong forum if you're looking for JQuery assistance.

 

Regards,

Jason

Hi Jason,

I am using JQuery grid to only show the data.

I am binding Cube data to JQuery grid.

This post is really old, so won't probably help @XLP-Main at this point.  We are planning on doing this.  Our plan is just to use update statements, e.g., since the writeback relational table stores the deltas, we can sum the deltas by key, then update the original source table for the fact with the original + delta for the keys, then delete the records from the writeback table.  Not sure how to deal with concurrent changes (user modifying while we are doing our cleanup) except to run during non-work hours to minimize conflicts.