Post reply

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

  • July 31, 2006 at 1:30 pm

    #113910

    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,

     

  • August 3, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • August 16, 2010 at 7:59 am

    #1207356

    Hello,

    I have the exact same issue.

    I would like to retrieve the data from a cube and to process it in relational sql server! Is this possible?

    I am using Sql Server 2008 R2.

    I am really new in SSAS. Please help.

  • August 17, 2010 at 5:06 am

    #1207737

    You can use OPENROWSET or OPENQUERY to retrieve data from a cube into your relational database. Check http://support.microsoft.com/kb/218592 for some examples.

    http://www.dwexplorer.com
    @dtwegener

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply