none
Add dimension in existing Cube with new a attribute in fact table RRS feed

  • Question

  • hi, I would like to add dimension in existing Cube that is new a attribute in fact table. Also I got lots of data in existing cube. How can I merge or keep old history data in cube? No previous raw data in fact table right now. I found when I add new dimension for cube, it need perform "Process Full" for the cube, it clear all old history in cube. How can I do? Thank you.


    Thursday, November 14, 2019 4:22 AM

Answers

  • Any method that I can merge old data in cube to new one? thanks

    No


    http://darren.gosbell.com - please mark correct answers

    • Marked as answer by alexchiu Friday, November 15, 2019 9:32 AM
    Thursday, November 14, 2019 6:55 AM
    Moderator

All replies

  • There are no other options here. If you change the structure of your measure group (fact table) you need to do a process full.

    http://darren.gosbell.com - please mark correct answers

    Thursday, November 14, 2019 4:33 AM
    Moderator
  • There are no other options here. If you change the structure of your measure group (fact table) you need to do a process full.

    http://darren.gosbell.com - please mark correct answers

    Any method that I can merge old data in cube to new one? thanks
    Thursday, November 14, 2019 6:39 AM
  • Any method that I can merge old data in cube to new one? thanks

    No


    http://darren.gosbell.com - please mark correct answers

    • Marked as answer by alexchiu Friday, November 15, 2019 9:32 AM
    Thursday, November 14, 2019 6:55 AM
    Moderator
  • Darren, thank you for your reply.
    Thursday, November 14, 2019 6:59 AM
  • Darren, thank you for your reply.

    If you add a dimension to the cube, the complete schema of the model would be changed, including related data.

    Well, if you have got a certain answer, please kindly close the thread by marking useful reply as answer.

    Thanks for your cooperation.

    Best Regards,

    Will


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, November 15, 2019 2:46 AM
  • If things go very very bad, you can pull detailed data from the cube itself with e.g. 'openrowset', which will let you do the necessary processing. Certainly not something to do unless desperate.

    Expect me to help you solve your problems, not to solve your problems for you.

    Friday, November 15, 2019 7:08 AM