Profile

Kshitija Marathe

BMC Software

Contact Details

BMC Software

My Content

1 to 3 of 3 total

Pentaho Metadata Editor - How to define formula for a Business column which refers to columns from two tables?

Posted By Kshitija Marathe 05-06-2024 02:23
Found In Community: Pentaho \ view thread
Hello Pentaho Team, I looked at the below doc: https://docs.hitachivantara.com/r/en-us/pentaho-data-integration-and-analytics/10.1.x/mk-95pdia007/pentaho-metadata-formulas/second-use-physical-table-column-formulas Here it is mentioned that we can refer business columns from two different Business tables ...

Pentaho Metadata Editor - Ability to define Filter criteria on Business Table

Posted By Kshitija Marathe 04-03-2024 07:50
Found In Community: Pentaho \ view thread
I am looking for a way to define constraint / filter criteria on Business table. for e.g: SELECT DISTINCT (`t1`.`c1`) AS C1 FROM `t1`  WHERE  (`t1`.`c2` = ('ABC')) Here (`t1`.`c2` = ('ABC')) is the constraint can be defined on Business table t1 using Calculation property. Want to check how it will take ...

Pentaho Metadata Editor - Issue with query generation when one parent table left outer joins multiple child tables.

Posted By Kshitija Marathe 05-25-2023 07:55
Found In Community: Pentaho \ view thread
Scenario: In business model , Below are the relationships defined: Table A is left outer joined with Table B  Table A is left outer joined with Table C  Table A is left outer joined with Table D  Table A is left outer joined with Table E Adding screenshot for reference: Based on this, I am looking for ...