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

dump measure table to relational table

0 views
Skip to first unread message

eljay

unread,
Oct 23, 2009, 3:07:28 AM10/23/09
to
Hi,

with ssis I can create a OLE-DB Datasource to access the dimensional
tables in an cube. The only think I have to do is to choose the MSOLAP.
4 Provider. In the dropdown list "Table or View" I find something like
[cube].[Dimension]. With a click on the preview button I can see all
dimensional members.

Now I need the same for the measures but in the list there doesn't
appear a table like [cube].[measure]. Can anyone give me a hint?

The idea behind this is that the SSAS cube is writeenabled an the
Users are able to enter there forecast values. I need this values in
other another applikations without direkt access to the cube.

0 new messages