Integration of 2nd Fact table in existing data model

[peschu123]

Hi,

I'm really stuck with this problem and running out of time...

I created an example file and added a screenshot of the table view.

I want to integrate the "capacity" table(it shows the capacity of the workstations/resources). I think it is not a big deal in general, but when it comes to date fields it drives me always crazy.

I want to use only one common date dimension. I tried to integrate it like explained by Rob Wunderlich:

http://robwunderlich.com/storage/qvtutorial/

But I think this doesn't work because the tables don't have the same keyfields. Ok. I tried to use %fauf-vorgang(production order-process) but this leads to some weird results if I just want to see the capacity by resource and date (without the dependency of %fauf-vorgang)

I don't know if my explanations make clear what I want to do. Feel free to ask if something is not unclear.

Thank you for your help in advance.

- PS -

[peschu123]

Nobody who can help?

Is the description too bad or the problem to complex? 😕

[b_garside]

Can you link Capacity table using the %RES-ID to the central fact table?

[peschu123]

Hi

bgarside. Thank you for your reply.

Yes I tried this and it works pretty well until you want to show just the capacity for a ressource at a specific date in a chart.

This happens because the Date-table is connected via %FAUF-Vorgang with PRODORDERS. There you find %RES-ID.

But the relation between PRODORDERS.%RES-ID and CAPACITY.RES-ID is 1 - N. The result is that you get many ressources for this %RES-ID for many dates. When you use CAPACITY.Date as seperate listbox item this is no problem. Perhaps there is some set expression magic to solve this problem?!

Regards,

- PS -