Add quick dimension to existing fact information source

Hi @washton ,

You can use Custom dimension connection window to create the required connection between FACT and QDIM.

for more detail check the the below documentation

Overview - Custom Dimension Connections (ifs.com)

Hi @washton ,

One more suggestion. If your ultimate goal is to generate an access view for just a custom dimension, You can develop a custom information source(QFACT) instead of QDIM. Then you can directly generate access views.

Hi @SandT,

I tried this, but I’m getting an error:

For context, I have the PURCHASE_ORDER_LINE_MVT data mart source enabled.

Just on your second point @SandT, I am considering that.

We will be using the access views for both the Purchase Order Line and the Supplier for Purchase Part data, so I thought having them connected with the single foreign key ID to join on would be handy, but ultimately it’s not a huge issue I suppose.

Hi @SandT, that has worked!

Thank you for your help, have a good day :)

Regards, William

Hi @washton ,

Great. You too!

Please do not hesitate to contact if you need further support.