Forum Discussion

JGG's avatar
JGG
Icon for Helper I rankHelper I
6 years ago

Correct data model and measures

Hi, I've realized I need to look clooser into my data model (getting to complex due to lack og planning and perhaps basic knowledge), so I created a simple test model:   I know I need a...
Need Help
nvprasad's avatar
nvprasad
Icon for Solution Sage rankSolution Sage
6 years ago

HI,

There are no product-level details in the "INCOME" table. I am wondering how we can derive product-wise income without this information.

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

JGG's avatar
JGG
Icon for Helper I rankHelper I
6 years ago

For each periode there is a link between the cust_id and the income and also for each periode a link bewteen the cust_id and the product. Isn't that sufficient?

  • nvprasad's avatar
    nvprasad
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Hello

    No, your income table must also have product details. then we can only get.

    Appreciate a Kudos! 🙂
    If this helps and solves the problem, please mark it as a solution! 🙂

    saludos
    N V Durga Prasad