Transformation of prebuilt model - mapping issues

[Sona]

Hello,

I need to make a transformation on a model from pre-built content from SAC. I rebuilt the model which cancelled the scheduled import job. So, during the new import I had to build a query. I used the very same query which was originally used in the model but there is a problem with measure and account dimension – I cannot finish mapping without at least one measure and I don´t know how to map it because I don´t see any measures in the query:

I had these “Deployed Artifacts” in the account dimension in the original model (before rebuilding it) so I know this one should be the measure – I just don´t have any source column on the left matching it (from the query).

Can you please explain to me what I´m doing wrong?

[N1kh1l]

sonias

Looks like its a case of moving from Account based model to a Measure based model. I would request you to put up a screenshot of data wrangling stage where we can see all source structure columns. I feel you would need a transpose of a source column. Please put up source structure columns to answer you better.

Nikhil

[Sona]

Thank you Nikhil,
these are the source columns and the last one (highlighted) is the transformation which I need to add to the model (formula SUBSTRING):

Or different layout:

[N1kh1l]

sonias

Not sure what is the data source (file/source system)

I feel now your Account dimension is redundant. In your original model I assume your Account dimension had one member called Deployed Artifacts. Try removing the Account dimension mapping and map the deployed artifacts to the measure. If you want to keep the Account then insert a column in source structure and hard code it with formula with same as existing Account member and then map this column to the Account dimension.

For the last column, Type Integration what dimension in model you want his mapped to. May be you can map this to account itself as its no longer useful.

Nikhil

[Sona]

Yes, you are assuming right - in the original model, there was only one member in the account dimension (Deployed Artifacts). I agree that the account dimension is redundant in the mapping but I cannot "unmap" it because it is not mapped. Both account dimension and measure are not mapped - they are both grey.

The problem is that I don´t see those Deployed Artifacts in the query on the right (in the very first picture above) so I have no chance to map Deployed Artifacts to Measure or Account dimension. And the query is from prebuilt content so it should be correct.

For now I made a whole new model with my own query and it was probably faster solution than to solve this. But I would still like to know what´s wrong here because I don´t understand it.