Setting Up DataLayer

Hello,

This is my first time use of SPOTFIRE. I am trying to setup Information Links. (example) We have a single dimension table and two fact tables. I have setup individually each information link for each table and joined all tables in project keeping my dimension table as default. But, I was unable to do cross table visualization by bringing in attributes from dimension info link and fact attributes.

Dimension table : Well (Made as a Information Link)

DImension columns - ID, WELLNAME

FACT table 1 - UP (Made as a Information Link)

Fact table columns - ID(PK which is ID of Dimension), DATE, FACT1, FACT2

FACT table 1 - UP2 (Made as a Information Link)

Fact table columns - ID(PK which is ID of Dimension), DATE, FACT11, FACT21

All table are join through Dimension ID in manage relation.

We would like to keep seperate information links as it gives users good option to pick the columns seperately. Is there any way to make this work. 

Needed output:

                    WELLNAME DATE  FACT1, FACT2, FACT11, FACT21

 

QUESTION 2: 

Is there any way we can do cross table Calculated columns. Like in example of information links structure shown above, FACT1/FACT11 can calculate a column. 

 

Login