Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Recieve user input for cube writeback

0 views
Skip to first unread message

Newbe

unread,
Oct 26, 2009, 7:45:03 AM10/26/09
to
How do I recieve and implement user input for (measure) cube input on
analysis service 2008?

Newbe

unread,
Oct 26, 2009, 7:47:53 AM10/26/09
to
How do I recieve and implement user input for (measure) cube writeback on
analysis service 2008?

Moby

unread,
Oct 27, 2009, 10:32:00 AM10/27/09
to
Did you already design your writeback settings including your
writeback table or are you looking within your BI-Studio?

if you are looking for the mdx?

UPDATE --CUBE
[Cube_Name]
SET ( [Measures].[Value], [Product].&[845] ) = 2;
COMMIT TRANSACTION;

and don't forget to commit. Otherwise the value is only availible in
your session.

their are a lot of third party frontends which have writeback and
commit as default functionality.

kr moby

Retha via SQLMonster.com

unread,
Oct 27, 2009, 10:40:08 AM10/27/09
to


All those work, but I want user to modify values in eg. Excell 2007 and then
those must be written back to my cube. My problem is to get the user input
back to the update.

--
Message posted via http://www.sqlmonster.com

Moby

unread,
Oct 28, 2009, 6:34:41 AM10/28/09
to
Excel cannot write back - thats sure. from what i heard, 2010 should

nevertheless
one old option was the cube analysis as an ms add-on for excel. but
this works only on older excel versions than 2007 and ist not
availible anymore

or you word with a third party tool.
as an excel add-in you may use xlcubed - www.xlcubed.com
find more under http://www.mosha.com/msolap/util.htm#Apps - Excel Add-
Ins

or you work with other third party tools like arcplan, bissantz,
cubeware, etc. they handle write back perfectly

kr moby

Retha via SQLMonster.com

unread,
Oct 28, 2009, 6:48:47 AM10/28/09
to

Moby,

Thank you for your reply.

Retha

0 new messages