Get Data from a module with dimensions to a module without dimensions

jakerlund
jakerlund
in Modeling

Hello,

I have a module with dimension "Invoice Number", in this I have Start Period and End Period for the invoice (it can cover multiple months). In another module without dimensions I want to be able to show which Start Period and End Period a invoice have based on if a boolean is true in the first module. Does anyone have any ideas on how to build this?

Best Answers

  • devrathahuja
    devrathahuja
    Answer ✓

    @jakerlund - In that case, I assume you want to select any 1 invoice & show the break-down of that invoice, you can achieve it as follows-

    Module 1 : Source Module-

    image.png

    Summary of Invoice # line item is firstnonblank

    You can also add a DCA such that once 1 invoice is selected the user cannot select any other invoice.

    Module 2 : Target without the invoice dimension-

    image.png


    You can then use lookup on the invoice number to fetch any data associated with this invoice.

  • jakerlund
    jakerlund
    Answer ✓

    Thank you @devrathahuja ! Works great

Answers

  • devrathahuja
    devrathahuja

    Hi @jakerlund ,
    Do you also have time dimension in the first module or are the start & end period a line item formatted with time period?

    In module 2, when you mention "without dimensions" - Do you mean without the invoice number dimension as well?

  • jakerlund
    jakerlund

    Hello @devrathahuja

    In the first module start & end period is a line item formatted with time period.

    For module 2, exactly, it does not have the invoice number dimensions.

    To further elaborate the use of it will be to filter my data module to show what data (resources, hours) is in the chosen invoice, and the "invoice number" list are dummy invoices so they are not possible to include in the data import.

    Thank you

Categories