Export Data

You can use SQL tools to export your applications data in a format that uses member names. Exporting using member names allows you to import the data using the Data Loader. This is useful when transferring data from one database to another.

Here is sample SQL statement that exports local data from the FinLoc fact table of a database with the member names used in the statement. You would have to substitute your dimension and member names.

select 
	 year.mem_name year_name, 
	 line.mem_name line_name, 
	 unit.mem_name unit_name, 
	 ver.mem_name ver_name, 
	 cust1.mem_name cust1_name, 
	 jan, feb, mar, apr, may, jun, jul, aug, sep, oct, nov, dec,
	 q1, q2, q3, q4, s1, s2, yr
	 from
	 year,
	 line,
	 unit,
	 ver,
	 cust1,
	 finloc
	 where
	 year.mem_id = finloc.year_id and
	 line.mem_id = finloc.line_id and
	 unit.mem_id = finloc.unit_id and
	 ver.mem_id = finloc.ver_id and
	 cust1.mem_id = finloc.cust1_id

You could also modify this to export exchange rate data from the XChange table.