how to make selection between two fact tables??

[sushil353]

Hi All,

My problem senario is...

i have to fact tables lets say A_FCT and B_FCT and other are dimention tables say ( L_DIM, P_DIM, O_DIM ) which are common to both fact tables.. fields in A_FCT and B_FCT are same but differ in data...

I want to make a report in such a way so that there may be a selection tab or field between these to fact tables.. means when ever a  user select fact table A_fct, all the reports and chart will be manipulated from A_fct table and if the user select B_FCT then all the chart/reports manuplates on b_fct table...

Please help me out how to load these table in qlikview environment such that they full fill my requirement... what would be the structure of loading..

Thanks..

[kaushiknsolanki]

Hi,

    If the Number of columns( Fields) abd the name of the Columns(Fields) in Fact_A and Fact_B are same then you can try this way.

    Fact:

    Load

         Field1,

         Field2,

         'FACT A' as Fact

    From Fact _A;

    Load

       Field1,

       Field2,

       'FACT B' as Fact

    From Fact_B;

    This will combine both the Fact tables into one Fact.

    Now you will have a new field Called Fact where you will have two values. i.e Fact A and Fact B

    So when ever you select Fact A, all data will be filter according to Fact A data. and vice versa.

    Hope you got what i mean to say.

    Hope this helps.

Regards,

Kaushik Solanki

[jagannalla]

Hi,

A_FCT:

     Load field1,field2,L_DIM_field1, P_DIM_field1,O_DIM_field1

     from A_FCT;

QUALIFY *;

UNQUALIFY  L_DIM_field1, P_DIM_field1,O_DIM_field1 ;

B_FCT:

     Load field1,field2,L_DIM_field1, P_DIM_field1,O_DIM_field1

     from A_FCT;

UNQUALIFY *;

- Now you can generate the reports based on different fact tables. Form A_FCT table take fields directly to the objects. But, for B_FCT the fields look like this B_FCT.field1,B_FCT.field2,......

But the dimension fields look same for the both tables.

Hope this helps you..