Okay. I am trying to make a family (this is just a test family for me to learn from) That uses the number in the Control Parameter to Adjust the Dimensions in the width, length, and height of my cube using a lookup table. I have the path to the lookup tables right in the .ini file and have the Tivis.csv name in the Lookup Table Name.
This is where I think I'm going wrong. I'm using this formula:
text_file_lookup(LookupTableName,LookupColumn,DefaultIfNotFound,LookupValue)
so I have:
text_file_lookup(Lookup Table Name, "RY", 0' 6", Control)
To me that says It'll look in the RY Column and the resulting "control number" Row and report back the dimension I have listed. If it can't find that the width will be 6". Am I right?? I can only get the 6" simension and I can't get it to pull the info out of the column.
Please Help!! lol
I uploaded my Family and the XLSX version of my CSV file since I can't upload CSV files.