Versions Compared

Old Version 4

changes.mady.by.user Sarabjeet Kaur

Saved on

compared with

New Version 5

changes.mady.by.user Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip

Tips

  • Mark at least one fact table. This will help in the auto-creation of relationships and semantic model. You should mark that file as Fact, which you want to use as a fact table in relationships.

  • Mark the primary key and foreign key. This will help in the auto-creation of relationships and semantic model in the next stage. Dimensions/measures will not be created for primary/foreign keys.

  • Hide columns that you do not need in your analysis.

  • Update format if needed.

  1. Choose the Preview Table image-20240226-102409.pngImage Added icon Image Removed to see sample data, and click Filter data to refine the data that you want to bring in for your analysis.

  2. Click the Next button. The system validates all your files and tables and displays errors if your data is invalid.

  3. The Define Relationships tab page is displayed with a set of relationships automatically created by the system.
    These relationships are created on the basis of data selected in the previous step and information about master data, fact data, primary key, and foreign key.

  4. If the system does not generate any relationships or to define your custom relationships, you can manually define relationships. For this, click the Add Relationship link.

...