topic Re: Link two fact tables with two dimensions in App Development

Link two fact tables with two dimensions

TinaH — Thu, 07 Apr 2022 07:51:12 GMT

Hello,

I am facing the following issue on linking two fact tables with two dimensions:

Lets say I have the following tables:

Fact_1

Fact_2

And a Link Table:

Link

In addition to the IDs, I want to link the time stamps as well to plot:

x-axis = time

y-axis = sum(Value_1), sum(Value_2)

How can I do this? I tried concatenating the two fact tables, but this is not working

Thank you very much!
Tina

NitinK7 — Thu, 07 Apr 2022 08:02:13 GMT

Can you please provide what output you want in X-axis and Y-axis based on your given table?

TinaH — Thu, 07 Apr 2022 08:06:19 GMT

Hello,

I want the following outputs:

marcus_sommer — Thu, 07 Apr 2022 08:15:53 GMT

Concatenating the facts is nearly always the most suitable approach. This means in your case something like:

t: load ID, Time, Value, 'Source1' as Source from Source1;
concatenate(t)
load ID, Time, Value, 'Source2' as Source from Source2;

and within the UI you could use the source-information to select, to dimension and/or to filter the wanted data-set, like:

sum({< Source = {'Source1'}>} Value)

- Marcus

TinaHensel — Wed, 13 Apr 2022 07:11:20 GMT

Thank you very much. With the concatenation, it is working fine!