April 9, 2013 at 11:45 pm
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
June 3, 2013 at 1:34 pm
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.
January 8, 2018 at 6:29 am
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.
July 2, 2020 at 1:29 pm
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply