Author Topic: Adding new dimension to existing Star Schema grouping  (Read 417 times)

Offline raj_aries81

  • Community Leader
  • *****
  • Join Date: Jan 2009
  • Posts: 167
  • Forum Citizenship: +0/-0
Adding new dimension to existing Star Schema grouping
« on: 01 Dec 2020 09:04:13 pm »
Hi,

I have an existing star schema grouping (shortcuts) in presentation layer which is based of a star schema created in Intermediate Layer. However, I have included a new dimension to this star schema created in the Intermediate Layer.

Just wondering if there is easier way to add this new dimension to the existing star schema grouping without having to delete and recreate the existing namespace in presentation layer, so that I dont have to reconfigure the object security again on the existing query subjects.

Any help is highly appreciated.

Thanks
Raj
« Last Edit: 01 Dec 2020 09:06:01 pm by raj_aries81 »

Offline bus_pass_man

  • Statesman
  • ******
  • Join Date: May 2008
  • Posts: 476
  • Forum Citizenship: +45/-0
Re: Adding new dimension to existing Star Schema grouping
« Reply #1 on: 02 Dec 2020 05:37:55 am »
You don't need to delete anything.

As you have observed, when you create a star schema grouping, a set of shortcuts are created in a new namespace. If you want to add a dimension to the star schema grouping, select the dimension and choose create new shortcut. Move the shortcut to the star schema grouping.  As it will probably have a name like shortcut to dimension, you can rename the shortcut to something more presentable.