List Box

[rathnam_qv]

Hi all,

i have Region field in 5 tables..when i selected one region 0field from one table  as a list box the chart which is created from that perticular table is getting populated.

Remaining charts are not....

Any solution for this...

Thanks in advance!!!

Smiley

[vikasmahajan]

Hii

This means region Field is not linked in your data model , you need to link it for affection of all the 5 tables.

Vikas

[rathnam_qv]

Hi Vikas,

but i am using Trasanctional level Data...no Schema and no predefined keys also

Smiley

[jagan]

Hi,

Create a link table for Region and link all other tables to this table.

RegionLinkTable:

LOAD

     Region

FROM Table1;

Concatenate(RegionLinkTable)

LOAD

     Region

FROM Table2;

'

'

'

Concatenate(RegionLinkTable)

LOAD

     Region

FROM Table5;

Hope this helps you.

Regards,

Jagan.

[kaushalview]

Hi,

Can you share your application?

Regards

Kaushal Meha

[rathnam_qv]

Thanks Jagan

[#7]

Try having the same field for all your charts the result must populate. if so then create an seperate dimension for the same and add the id's to the fact table

Thanks,

Shyam