Calculate # dimension rows per fact row

[#1]

Hi,

Probably this is very easy, but for some reason I don't succeed in getting (in the load script) the number of matching dimension rows per fact row.

Example attached as well.

Any advice would be appriciated.

Maarten

[Aurelien_Martinez]

Hi,

See this QV file

[#3]

Hi Aurélien,

That would indeed be a good solution if there was no need to calculate the result in the script.

In my case, the best solution would be to have the result as field value.

I can easily solve the problem by using an outer join, but I'm now sure what the impact will be in the real script.

E.g.

[marcus_sommer]

I think you could use table-functions like noofrows() for this.

- Marcus

[#5 · Accepted solution]

In the end I was able to solve the problem with the following code.

Did some tests and the results seem to be ok.

Thanks for your feedback.