MS SQL Server OLAP

Author

Writeback

Saru via SQLMonster.com

2005-09-23, 9:23 am

Can the writeback funtionality be made session specific? I mean multiple
users could write back into the same cell and would see their respective
values. Can that be done?

thank you

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

Darren Gosbell

2005-09-26, 3:23 am

Writeback works by storing the writeback data in what is essentially a
copy of the fact table.

So unless the users were all working in separate parts of a hierarchy,
which was secured so that the could not see each others data - I do not
think this is possible.

--
Regards
Darren Gosbell [MCSD]
< dgosbell_at_yahoo_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell

In article < 54CB41A7012E4@webser
vertalk.com>, forum@webservertalk.com says...
> Can the writeback funtionality be made session specific? I mean multiple
> users could write back into the same cell and would see their respective
> values. Can that be done?
>
> thank you
>
>
>

michael v

2005-09-26, 1:24 pm

Perhaps you could use dynamic security to show it per user. The user is
actually logged in the write back table.

"Saru via webservertalk.com" <forum@webservertalk.com> wrote in message
news:54CB41A7012E4@w
ebservertalk.com...
> Can the writeback funtionality be made session specific? I mean multiple
> users could write back into the same cell and would see their respective
> values. Can that be done?
>
> thank you
>
>
> --
> Message posted via http://www.webservertalk.com

Sponsored Links