Find a value in a non relational table

[#1]

Hello,

I have a traditional model of a compagny which sales on internet, like this

Table Product

Table Sales

Table Country

Table Customers

And I will like to add the target. It's very difficult to change the model and add target in the model.

My idea was to create a table Target and it has not relation with the model.

I find the function pick(), match()... but I don t know if is possible :

My target is looking like that

Month1 | Product1 | SalesTarget

Month1 | Product2 | SalesTarget

....

And I would like to create a table like this

Month1 | Product1 | Sales | SalesTarget

Month1 | Product2 | Sales | SalesTarget

Do you know if it's possible ? Wich function can do that ?

[pennetzdorfer]

I guess this blog post (+ technical brief!) might help you: Fact Table with Mixed Granularity

Regards,

Florian

[#3]

Yes thnks but like I said, it's very difficult to include targets in the model /:

[#4]

Any help?

(In fact I would like to find value in a table with specific columns and values)

[#5 · Accepted solution]

Ok I changed the model and add target to the sales table

thanks everyone!