Hi There,
Wondering if there is an effective way of loading data from a SQL view into Contributor via the import data; I know it needs to be loaded to the im tables, but cannot find an effective set of instructions to set this up. This is in 10.1.1.
I could create text files and have tested the view as a concept , but would like to load directly for a set of cubes from the SQL database.
Any help?
Load data into im_ tables in application database and run prepare import macro in contributor.
Import errors are logged into ie_ tables
Thanks Ykud,
What I am looking for is some instruction set on loading the data into the im- tables. Do I use a SQL query, and if so, what kind of query?
It is not readily available on any big blue site.
Just for interest sake and to note the solution:
I ended up using SQL Server Management Studio, and using the following steps:
1/Connect to the Target Database Server, and right Click on the target database (Contributor application)
2/ Select Tasks / Import Data
3/ Select Source [Database server, and then select the relevant source database (in this case a publish view from the old 7.3 environment)
4/ Select Copy data from more than one table or view
5/ Select the Source Tables to copy (in this case ev_tablename)
6/ Identify the appropriate Target tables to copy to (in this case - and typically always - im_tablename)
7/ Edit mappings, and select the Destination for exportvalue as importvalue.
8/ Repeat steps 5 - 7 for all tables to be copied.
9/ Select Next / Next (run).
This copies the tables selected to the im_tables in the target Contributor database. From there it follows standard documentary process:
10/ Prepare the cubes for which data is imported; in this case I zeroed them also
11/ GTP the application.