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.