Quickly duplicate a dimension?
Hi i would like to copy a dimension, we could write it into our ETL but if I can do in Discovery or Formulate then it would be cool. In Tableau I would create a calculated field "=DIMENSION_NAME" and make the calculated field into a dimension.
I'm struggling to find a way to make a direct copy of a dimension in Formulate though. Any ideas please?
3 replies
-
Just realised ive been forgetting to specify Context in the Formulates, which explains half the problem ive had so far :) doh
-
The ability to add a virtual column to an existing model outside of the modeling tools is not yet supported except with specific items like dates , outliers, clustering etc. We plan on adding this in the future and it will allow you to do this and more. (Although creating a duplicate dimension is somewhat redundant unless it includes some manipulation or calculation).
Unlike Tableau, where your model is local and specific to the project (and you), Pyramid has to ensure we come up with a technique that handles the shared model construct on a shared platform that may be used and accessed by multiple users in multiple projects - which makes the mechanics significantly more complex. Never the less, its on the agenda.
-
Thanks Avi, so ETL for now that's good to know thanks