What is the best practice to link this model?

[#1]

I need all the sales and goals by product group and sellers.

How can I relate the tables the sales and goals?

Thanks.

[vikasmahajan]

Dear Robson

Possible solution for your qv is to use LINK TABLE concept because your tables having mostly common fileds

Search Link table on community you will get lot examples for link , still you are not getting please reply.

Regards

Vikas Mahajan

[#3]

Hi Robson, I am not sure of your logic. Assuming the Goals table / class is Sales Goals, I would map the Seller (Apply the map on IdSeller) table to Sales and exclude the GrpProd from Goals (If however the Goals are product Goals, I would exclude the idSeller field). Then I would Map Goals to - Prod if the Goals are for product - or to Sales if they are Sales goals. Again - it all depends on your logic.

[Jason_Michaelides]

Hi Robson,

Your challenge is that you sell products but target (have goals) on product groups so standard "best practices" won't fit, at least not without a little extending...

I'd create this model I think:

I've attached an example of how.

Hope it helps!

Jason

[#5]

Thanks Jason,

but i need show all data of products group for instance.

Jason, Small Fish

Jason, Big Fish

Jason, Weird Fish

even jason has not sold any big fish, but i need show this..

how can i make this?

[Jason_Michaelides]

In my example data, Jason has no sales OR goals for anything other than Small Fish.  If Jason had some sales, some goals, or both then those product groups would be in the table - he doesn't need to have sold any, as long as he has at least a goal.

Is that OK, or do you always have to see all possible Seller and Product Group combinations.  There is a way to achieve this but it gets a little complicated...

Jason

[#7]

In my case i need see all possibilities of sales and product groups.

Robson Henrique

[swuehl]

If you pivot the product group to the top of your table, you will see all combinations in a matrix (as long as there are some data of any seller for the fish and the seller has data for sale and goal for any fish).

Maybe this presentation is ok for you or your customer, then you don't need to change anything.

[Jason_Michaelides · Accepted solution]

Well swuehl's solution is easier than mine!  I've updated the script to give you all possible combinations of all the dimensions...see attached.

Jason

[#10]

Thanks Jason!!!