Linking two modules with two different dimension

Hi All,

I have an issue that I may need some help with. Below is the sample table:

Gencon Module (Source) - GenCon List

Inventory Module (Target) - Inventory List

Gencon Module is the transactional data of the client. In the Gencon Module it is normal to see multiple transaction code with different Start Date, End date and Status.

Inventory Module is the filtered version of the Gencon Module. Only the Transaction ID with Fully Paid status and those transaction ID without duplicates and End Date will be displayed as Unsold.

The Inventory Table above is the expected result. The Table below is the current result that we got:

we tried using If else condition but we have an error level dimension mismatch.

Appreciate the help.

Regards,

Accepted answers

Ingilavicus

Hi,

The first thing that comes to mind is adding value to status, assuming that Transaction is a dimension and in the source, the transaction column is formatted as Transaction dimension and in the result, the transaction is one of the dimensions. So by adding value to Status and summing it up you could decode what has happened, and if it's more than two then you might find something like paid twice if that's possible.

Andris

All comments

Ingilavicus

Hi,

Andris

Jsdeloria21

Hi Adris,

Appreciate your feedback. I did flag the item from the source to determine which of the code has a status of Fully Paid. The result of the target module should return the status of the unique transaction code with only Fully Paid status and Transaction code that is unique whether it is cancelled.

Regards,

Quick Links

Can you help?

Unanswered questions

Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…