Exactly !!! Like Ber Hommelberg said.
I only make separate DM's but the concept is the same. I call them Conform DM's and put them in a separate source folder
1: Conform: Time_DM (with al my Time_Dims and (Alias))
2: Conform: Regular_DM, (all the regular Dims and Alias)
3: Conform: Fact_DM (All my Fact tables)
In these DM's I select the Dims from my DB/DWH source and add them to the DM.
From here I make the properties that I want and the presentation correct. (Here you also make your alias Dims if nesseseray)
You do not set joins in these DM's. You end up with the Ingredients for making the Starschema's.
In my business folder, I make the new star schema, open been new DM and as a source select the Conform DM's as Source.
Only have to select the dim and fact that I want for the star schema. Drag and drop from the source into the DM. Set your joins, and add maybe additional calculations for your schema. (remember, Fact and Dims are Green, you cannot change them here only in the original Conform DM).
and voila you're done. making your new starschema in DM.
Is there a new Item in your Product dim ? No problem. Go to the "Conform: Regular_DM" and add the item from the DB source to the existing Product_Dim.
Make any name modifications en properties and save the DM. Every other Star schema that is using the Product_Dim from the "Conform: Regular_DM" automatically get the new Item visible.
1: DB -> Conform DM
2: Conform DM -> Starschema DM
3: optional, If you have multiple Starschem DM, you can add these all together in 1 BIG presentation DM.
Hope this helps if you are switching from Framework to Data modules:
It can be done, and it is not that hard, BUT the approach is different from Framework manager.
------------------------------
Maarten den Dunnen
------------------------------
Original Message:
Sent: Tue April 20, 2021 02:39 AM
From: Ber Hommelberg
Subject: Grouping Star schema tables in Data modules
You can achieve single point of definition for star schema s with conformed dimensions with DataModules. Just create one DM for all your facts and dimensions. Then for every starschema make a presentationlayer by defining a new DataModule based on the first big DataModule.
------------------------------
Ber Hommelberg
a.s.r.
Netherlands
Original Message:
Sent: Wed April 14, 2021 07:12 AM
From: Vivien
Subject: Grouping Star schema tables in Data modules
Hi Thomas,
The official documentation says : In both modeling tools, you can create reusable objects and layers of abstraction.
regards,
------------------------------
Vivien
Original Message:
Sent: Wed April 07, 2021 10:17 AM
From: Thomas van der Meer
Subject: Grouping Star schema tables in Data modules
I want to convert the existing Framework manager module to a Data module. But I don't know how to convert the conformed dimensions in the FM model.
I have for example an Organisation dimension which is linked to multiple fact tables. In the FM model Presentation view there are several folders and in the folders there are namespaces with the shortcuts to the Business View. So it is possible to create several shortcuts to the same Query subject (in this case the organisation dimension) in different namespaces. This is very useful because you can group related query subjects which is convenient for the end-user.
I know that I can create a view and folders in a data module, but that is not the same as the shortcut functionality in FM.
How can I achieve this in a data module?
------------------------------
Thomas van der Meer
------------------------------
#CognosAnalyticswithWatson