2 Replies Latest reply: Aug 12, 2011 2:53 AM by Jagan Nalla

# how to make selection between two fact tables??

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...

Thanks..

• ###### how to make selection between two fact tables??

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:

Field1,

Field2,

'FACT A' as Fact

From Fact _A;

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

• ###### how to make selection between two fact tables??

Hi,

A_FCT:

from A_FCT;

QUALIFY *;

UNQUALIFY  L_DIM_field1, P_DIM_field1,O_DIM_field1 ;

B_FCT:

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..