lookup from external data source

Abouelfadl — Mon, 01 Apr 2024 18:27:49 GMT

Hi,

I've multiple dashboards built from ERP source (SAP) . how to replace the values based on lookup from an external Excel sheet?

do I need to create a new business schema and merge it with the existing one ?

No like to update the data in source system (SAP).

looking for the fastest way to visualize based on new values

Re: lookup from external data source

RADSr — Tue, 02 Apr 2024 19:11:49 GMT

Upload your lookup table ( Excel sheet ) as a data source. Create a table from that data source and make sure to designate the key column(s) which exist must exist in the SAP source as well ( otherwise, well, it wouldn't have any way to "look up" 😉 ).

Load your lookup table.

In your SAP-based Incorta table create a formula column: lookup(LUTABLE.RETURNVALUE, KEYCOLUMN, KEYVALUE ) <<< look at the doc for the lookup function, you can use more than one key if applicable. The key must be designated as a key in the lookup table for the lookup function to work properly.

[edit to add] You can also join your SAP table to the lookup table ( SAP table as the child ) and then the formula column is just the qualified column name from the lookup table. Or don't create a formula column at all and only include the lookup column in the business schema. Options abound!

topic Re: lookup from external data source in Dashboards & Analytics Discussions

lookup from external data source

Re: lookup from external data source