Concatenation problem

[poonam_kulwal]

Hi All,

I have 2 tables in my data mode.

Purchase Table

Product

StoreName

LastPurchaseDate

Sales Table

SalesID

StoreName

SalesDate

Product

I have concatenated these two tables with other tables in my data model.

Now on UI side, I have two pages

One shows information about Purchases in straight table.

Product

StoreName

LastPurchaseDate

Other page shows information about Sales in straight table. One SalesID can have multiple Products.

SalesID

StoreName

SalesDate

Product

My issue is, when I make any selection on first page and navigate to second page and make some more selections, all selections on first page get cleared off.

And when I make any selections on second page and go to first page and do selections on first page all selection on second page gets cleared off.

The reason behind this is I am concatenating two tables. Is there any way to solve this issue? I need to stick with concatenation. I can’t change my data model.

Appreciate any suggestions on this.

Thanks & Regards,

Poonam

[Anonymous]

you could use a separate (inherited) alternate state for each sheet...

[ziadm]

You should not concatenate the two Table.  Your Sales is your Fact Table and Product is your dimension Table

You need to find a key to link Sales To Product Table and I think the the Field ProductNo is your Field

Also suggest to read this

Concatenate vs Link Table

[Digvijay_Singh]

You got mulitple records for sales and purchases for a single product by the concatenation in the data model. So when you are making selection in the purchase record it will skip sales record and vice versa ( I assumed that you are making selection in straight table directly).

Since you don't want to change data model you need to decide on some workaround to handle this. What if you lock your straight tables and don't allow any selection and use product filter(list box) to make selections. I think when you make selections only through product drop down, it should show both sales and purchase records for the selected product. Not sure though, may be I am missing some facts

[poonam_kulwal]

Hi,

Robin I cant use Alternate state. This will not help me to resolve my issue.

Though I used BookMork, but It will create problems for other tables.

Digvijay, My client wants selection on Straight table. On any selection of straight table they want to see corresponding details on rest of the other tabs.

Ziad, I have total 7 tables with Master Calendar. I have concatenate all tables and linked to Master calendar. I have no idea whether link table concept will work in my scenario.

What about Data Island? Could you guys feel if I go for Data Island then that will resolve this issue?

Appreciate you replay.

Thanks & Regards,

Poonam