Compose DataMart

[mopidesp]

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 ?

[TimGarrod]

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_Impo...