Accessing the actual data in a wrte back enabled SSAS cube

Question

Accessing the actual data in a wrte back enabled SSAS cube

arobind-314985

Valued Member

Points: 74
More actions
March 30, 2006 at 12:06 am

#171814

I have write enabled my SSAS cube
After that i edited a cell value from 50 to 100.From now onwards when i am querying the cube using ordinary MDX query i am getting 100 only.
I came to know that while writing back we are not touchin the deployed cube at all.
Then how can i see the actual data inside the cube,ie how can i see the value 50

Kindly advise

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

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

Patrick-153086 SSC-Addicted Points: 479 More actions · Answer 1

Guys, correct me if I'm wrong....

In AS2000, when you activate the write back capability of a cube, you also specify where to keep the changes (Writeback Table). AS will create a new partition having your WritebackTable as datasource.

So, when you browse your cube, you will get the merged values between your "normal(s)" partitions + your Writeback partition.

If you want to see your old values, you will have to undo your changes by trunkate the WritebackTable (or deleting rows you want to rollback) or remove the new writeback patition.

Hope this helps

Patrick

arobind-314985 Valued Member Points: 74 More actions · Answer 2

Thanks for the reply Patrik

But I like to see the difference between the edited value and the actual value.

That means, i have to see the writebacked value(changed value) and the original value in the fact table.Typical budgeting application.

So by keeping the writeback table, i have to see the original values.

Kindly advise.

Regards

Arobind

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 3

Do you (could you) have a Scenario dimension? If so, then assume the 'base' data is scenario 1, change the dimension to scenario 2 and write back your figures. If you're using this for budgeting/modelling then this would let you see the different figures based on differing scenarios. What I would be aiming for is to be able to create new scenarios on the fly (or almost anyway) and in doing this, copy all of the values from another existing scenario (the base scenario or perhaps another one you've already created).

Other than using a dimension to differentiate them, I can't see how you'd see both of the values (ie a single cell has only one value for each measure).

Steve.

arobind-314985 Valued Member Points: 74 More actions · Answer 4

Actually the value that i am going to edit is a measure

So the requirement is to see the original and changed values of a measure column simultaneously in a client application like pivot table

stevefromOZ SSC-Forever Points: 43646 More actions · Answer 5

That is why you could use a scenario dimension, this allows you to edit the emasure value for a particular scenario.

If you don't provide a way to differentiate the two measure values, how do you anticipate viewing both at once? Using normal write back, as you've seen the current measure value is replaced - there is no (easy) way to show more than 1 value within a single cell within a crosstab. The way you would normally do this is to use a dimension - the members within the dimension allow you to se both measures.

An alternate would be to have two copies of the base measure, use writeback on one and not the other. You could then see the original and revised measures at the one time.

Using scenario dim....

Scenario 1 (write back to this scenario)

Scenario 2

Your Measure

Account 1

$50

$100

Account 2 ….

$75

$120

Using two measures...

Measure 1 (writeback)

Measure 2 (base)

Account 1

$50

$100

Account 2 ….

$75

$120

Steve.