Calculated dimension in Import model in sac

[former_member845279]

Hi.

I want to have in an import model a calculated dimension.

I don't want to do it in the source or in the story because I want that if it is changed I do not have to reload (there is a lot of data and can do the final user) or update all the stories created.

Kind Regards.

Elena Cuezva.

[former_member845279]

First a lot of thanks to both.

The models are complex and need charge it in several blocks, and the user wants make the change himself.

In the origin we can calculate the dimension, but the problem is that the user can´t do it and need recharge.

If we put it in the "mapping", we can't change the formula and need a new "mapping" (import job).

If we create a new model, we need charge again and have a similar problem, recharging data.

We can do it in histories but the problem is that the logic changes, the user have to change it in all of histories (and can have a lot of histories), so that it would be very useful to us, have a dimension calculated in model in execution time, not in charge time.

Kind Regards,

Elena,

[William_Yu]

Hi elena.cuezva,

I don't think there will be a quick way to do it if you DON"T want to reloaded the data. To the relative easy way (no touch on story needed) would be to reload the data by follow steps:

1. Add a new dimension into the model in modeler.
2. Clear the data in the model
3. Recreate the import job to load data with a calcualted column and map to the all dimensions(including the new one) as suggsted by Aleksey.

If reload model data is NOT possible(due to whatever reason), probably you need to think about using a second model, steps:

1. Copy a new model from original model without data.
2. Add a new dimension into the model in modeler
3. Write a data action with advance formula to copy data from original model with logic to do the mapping
4. Replace the old model with new model in every story( one step for each story).

Best regards, William

[avsalynin]

elena.cuezva

when creating a model import, you can make a calculated column (for measures & dimensions)

or make transformations as a result of which, a new column will also be created