They wanted this to be imported into OBIEE, but couldn’t get OBIEE to see the data. They got the connection oke, but didn’t "see" the tables. This problem was caused by the fact that the generating application didn’t prep the data. It didn’t set the named ranges for the three tables.
Here is how you do it by hand:
Select a range:
Enter a range name and press enter!
Do the same for the two other tables:
Here is how you do it by VBA code:
Columns("A:B").Select ActiveWorkbook.Names.Add Name:="MY_TABLE_RANGE",
RefersToR1C1:= _ "=Sheet1!C1:C2"
When you now try to import the data into OBIEE you will see the three tables:
Till Next Time
Note: don't forget to disable the count distinct feature: