Stuck with Market selection

[Anonymous]

Dear All,

I have one issue that when I GL_Market_DIV as Regulated then I don't below regions

Africa

Asia

CIS

Middle East

South America

West Indies

But It is showing Please tell me how can i do this

Expected output when select GL_Market_DIV as Regulated

[Anonymous]

select Market_Segmnt = Regulated Market instead to get that output.

[Anonymous]

Hi Deran,

I know when i select Market_Segmnt = Regulated then i will get output but I want from GL_Market_DIV the desire outpout

[Anonymous]

gwassenaar‌ / ALL

Any ideas???

[rahulpawarb]

Hello Vijay,

Table DIM_QV_Customer is connected with VALUE_ENTRY table based on Customer_Code field; DIM_Division_Master table is linked with VALUE_ENTRY table on Div_Code field. As per my observation DIM_Division_Master table has inconsistent Customer_Code values against Div_Code compared with Table DIM_QV_Customer. Therefore it is not showing expected results.

You can get expected results by applying INNER JOIN with Table DIM_QV_Customer while loading DIM_Division_Master table.

Hope this will be helpful.

Regards!
Rahul

[Anonymous]

Hi Rahul,

Can You please help out.

Thanks

[rahulpawarb]

Hello Vijay,

Looking into it. Soon I will provide you updates.

Thank you!

Rahul

[rahulpawarb]

Hello Vijay,

Based on provided data files I have prepared a draft version of sample application. Please refer the attachments.

BTW, joining two different tables may result into data loss. Be cautious while applying a join.

Regards!

Rahul