Changes In Dimensions And Historical Cube's Data

[Shrikant Bang]

Hi Team,

    We have a use case where dimension's data may get modified ( slowly
changing dimension (SCD)).

  Here is example:

Fact :
   user_activity (
        user_id STRING,
        country_code INT,
        ....
  )

Dimension:
  country_dim (
      country_code INT,
      country_name STRING ,
     ....
)


Let's say we have mapped country code 1 to  'example_country1' and keep
building cube for years. Now country code 1 is assigned to
'new_country_code1'.


I have below query:

   1.   Is there any way to update the cube or it has to rebuild for all
   past time segment?
   2.  Can we join cube data with other dimensions on runtime ( changing
   dimensions table) , something like look ups?


Thank You,
Shrikant Bang.