Connecting to AS400 from SSAS 2008 Project
Posted on 2009-12-16
I am trying to connect to AS400 server using IBM iSeries Access for Windows from an SSAS 2008 project (from BIDS). I am able to create a datasource to the AS400 Server using IBMDA400 provider and the connection test is also successful. But when I try to create a data source view based on this datasource, it is not dispalying any tables/views from the underlying AS400 database. Why is it not displaying the tables/views list?
Secondly, I have created a blank data source view based on this datasource. Then I have tried to create a named query using a query (which fetches the data from a table from AS400 database). It is able to resolve all the columns names (ie it is replacing the * with the column names) and when I run the query in Named Query definition window, it is giving the results. But when I click on OK button to save the Named Query, it is not displaying the columns names in the DSV pane and the Named Query is not getting recognized when I try to select a table from the existing DSV while creating a Dimension. Please do let me know the reason for this. Bit urgent.