using applymap to filter
// load dimension
// create filter: table with 2 column, cust to join with Opencall_table and location to filter
Map: Mapping LOAD cust_id, location resident Userdb_location;
// load facts filtering by location of cust_id
// applymap(mapping table name, field in input, value if not found) returns the second column
ApplyMap('Map', cust_id, 'N/A') = 'CLO'
I have the following load script, however I cannot get it to work properly, would someone be able to help me with this please?
keysearch as cust_id,
SQL SELECT callref,
SQL SELECT firstname,
Thanks for the script, it seems to have joined the tables, however when I enter a where clause into either the SQL query or in the load section, it pulls through CLO in the location table, but it still shows all the data such as Callref. If I select a call ref that is not location = 'CLO' it grays out CLO. Basically I dont want any of the end users to be able to see anything other than call reference relating to CLO.
Can this be done at all?