March 6, 2009 at 11:33 pm
Dear All,
I am using oracle database for my project. i have created cube then the cube is stored in sql Analysis services. now i am add one more table is time for my project. then i generate the relation schema for my project the following error occcured.
error: "The target server is not sql server". what is the problem and how to solve it.. kindly help me...
March 8, 2009 at 5:43 am
Not sure what you are trying to do exactly. Can you provide more information as to what you are attempting to do and the steps that you are taking? Are you trying to create a Report Model off the SSAS database? If so you would do that within Report Manager off the deployed SSAS data source. You can do that by going into the data source and clicking on the Generate Report Model button.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
March 12, 2009 at 5:38 am
Dear sir,
I am new for ssas. i want to write the SP in my database. where to write the SP in my database.
i copy this code from net... i want to know where to write the code like this.what is ADOMD . how it is used .tell me steps for this
String ml_MDXquery = @"SELECT ([Measures].[" + m + "]) on columns,([" + d + "].[" + a + "].DefaultMember) ON rows FROM [Cube Demo]";
Microsoft.AnalysisServices.AdomdClient.AdomdCommand ol_AdomdCommand = o_AdomdConnection.CreateCommand();
ol_AdomdCommand.CommandText = ml_MDXquery;
AdomdDataAdapter ol_AdomdDataAdapter = new AdomdDataAdapter(ol_AdomdCommand);
DataSet ol_DataSet = new DataSet();
ol_AdomdDataAdapter.Fill(ol_DataSet);
GridView(ol_DataSet.Tables[0]);
March 12, 2009 at 6:22 am
If you are trying to access the SSAS information by using a stored procedure in your database I know how you can do this in SQL Server, but not sure how it would be done in Oracle. You would need to setup a Linked Server and then you can use an OpenQuery to access the information in SSAS. I have an example of this in this posting here Using Reporting Services (SSRS) with SSAS data.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply