Compose DataMart

mopidesp — Fri, 14 Mar 2025 20:49:07 GMT

Can some one please clarify the below question ?

Under the Root project, developers have developed their data marts . Now I wanted to move their facts and dims in to the main Data Mart. I see that an option to import dimensions but not facts.

Just wanted to check what is the work around for this ? We don’t want to do the development in the main data mart directly. Can you please suggest ?

Re: Compose DataMart

TimGarrod — Fri, 09 Apr 2021 19:34:06 GMT

You can only import Dim's across data marts.

If you have a fact table to migrate, I recommend reviewing the CLI features to migrate objects. Assuming you have DM_DEV and DM_PROD as your DEV and "PROD" DM - You would need to -

Export the Data marts via CLI. This will provide

DataMarts csv file which has a list of all the DM's
A folder PER Data Mart
Within each folder -
- dimensionattributes
- dimensions
- factattributes
- FactDimensionsLinks
- facts

The CLI currently only supports IMPORTING NEW objects. So you would want to -

remove the DM_DEV datamart line from the DataMarts.csv file as you don't want to import into that
remove all the files from DM_PROD folder
Move the facts, factdimensionlinks and factattributes csv files from DM_DEV folder into DM_PROD
Execute the IMPORT function of the cli to import the fact tables only into the DM_PROD datamart.

I recommend taking a VERSION of your project before doing this ;)...

Migrating via CLI is in the documentation -https://help.qlik.com/en-US/compose/February2021/Content/ComposeDWDL/Main/DW/Projects/Exporting_Importing_Data_Marts.htm

topic Compose DataMart in Qlik Compose

Compose DataMart

Re: Compose DataMart