Copy table to create an alias (Tabular model)

• Ian C0ckcroft

  Hall of Fame

  Points: 3373

  More actions

  April 9, 2013 at 11:45 pm

  #147976

  Hi guys,

  does anyone know how to copy and paste a table to create an alias with in a tabular model.

  e.g. I need 4 date dimension. start date, end date, resolved date and status change date. Each exactly the same with 2 hierarchies.

  Creating each one from scratch is a bit of a ball ache.

  anyone?

  cheers

  Ian Cockcroft
  MCITP BI Specialist

• Junior Vidotti

  SSC Journeyman

  Points: 82

  More actions

  June 3, 2013 at 1:34 pm

  #1620698

  I am looking for a solution too. I have more than one cube, and want to copy my date dimension from one cube to another.

• ephilipse

  SSC Enthusiast

  Points: 197

  More actions

  January 8, 2018 at 6:29 am

  #1974885

  A bit of outdated forum request.
  The tabular model generates a json file, default name is model.bim.
  It is possible to open the file in for example notepad++. Somewhere after the remark "tables": you can copy the part for the dimension you would like to copy. When copying note to make sure to modify the "name":
  Also make sure to make a copy of the .bim file before trying this.

  Like this it is not all that hard to do.
  

• linuxtbmc

  Newbie

  Points: 1

  More actions

  July 2, 2020 at 1:29 pm

  #3767007

  I think the best to do is creating a calculated table and then use the RelatedTable DAX function to clone your table.

  Indeed, I have a user table and two fields in the fact table: createduserid and modifieduserid I cloned the user table and created a link for each relevant field.