Storing Data from Variable to QVD

[Kaushik2020]

Dear All, 

I have a situation where I am thinking if below scenario is possible or not. Below a sample on how the data is loaded step by step. 

1. Load Data model via Binary Load.

2. Created 50 variables via Load editor. 

I am looking for an option, it it is possible ? Call a column from the Data Model --> EmployeeName + these 50 variables  into a QVD ? 

So the Store option will store these Dimension (EmployeeName) and these 50 variables as a measure into a QVD.

Thanks in advance. 

[marcus_sommer]

In general it's possible - but it may depend what the variables contain respectively if they should be evaluated in any way. I assume that not calculated but static variable-values should be stored else any kind of evaluation - and then it's quite likely not trivial anymore.

[Kaushik2020]

Thanks a lot for your swift reply. its a set expression -- sample one is here --> Sum( {$<Year={2021}>} Sales )

If we have just a simple measure, Sum(Sales) then we are able to store it from a variable to a QVD. 

[marcus_sommer]

Until the load has finished only table-data exists and not a data-model. Therefore no measurements like a sum(Field) could be directly queried.

But it's possible to run n loads within any loop against the loaded tables which perform the aggrgeation + conditions and fetching there results per peek() which may then loaded within an output-table. It depends on the requirements and the detailed circumstances how suitable such approach may be or if there are other and easier ways to get the needed data and views.