Retrieve DATA from relation db from within a Cube (calculated member)

Hello,

I need the ability to retrieve data element that is stored in a relational DB from within a cube (calculated measure). Is there a way to do this? If so, can someone please indicate how? If not, is there a way to store some data which is really independant of any measure or dimension in a cube?

I appreciate your help in advance.

Thanks,

Not sure what your question is. The cube you build contans data Analysis Server reads from relational database. By accessing cube you access copy of the data retreived from relational database.

If you would like Analysis Server not to store copy of relational data, you can define storage mode for AS objects as ROLAP. In this case MDX queries will generate SQL queries ( if data is not cached ).This mode obviously gets you poor query performance compared to MOLAP storage mode, which is default mode.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.