Forum Discussion

RaulPBI's avatar
RaulPBI
Helper II
9 years ago
Solved

PROBLEMS WITH TIME INTELLIGENCE

Hello everybody.   I have a problem with a model. It contains only three tables, one of them is date, and the rest are fact tables, costs by date and shipments by date. The thing is that I am not a...
Need Help
  • RaulPBI's avatar
    RaulPBI
    9 years ago

    Hi,

     

    I have solved it by this way:

     

    I have created another column in fact table which is date too, like this:

     

    Calculated date = albaran_salida_fechas[create_date].[Date]

     

    then I changed the relationship between these two tables, so "date" in calendario table is connected by"calculated date" with fact table. That´s perfect for me.

     

    Thanks for your time

TomMartens's avatar
TomMartens
Super User
9 years ago

Hey,

 

so it seems, that you have to provide sample data, from where your problem can be reproduced.

 

Regards

RaulPBI's avatar
RaulPBI
Helper II
9 years ago

Hi,

 

I have solved it by this way:

 

I have created another column in fact table which is date too, like this:

 

Calculated date = albaran_salida_fechas[create_date].[Date]

 

then I changed the relationship between these two tables, so "date" in calendario table is connected by"calculated date" with fact table. That´s perfect for me.

 

Thanks for your time