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.
WELLNAME DATE FACT1, FACT2, FACT11, FACT21
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.