Re: OLAP (Analisys Services) from .NET for WebPages
anonymous_at_discussions.microsoft.com
Date: 04/01/04
- Next message: Jón Sveinsson: "How to create install scripts to import olap cubes"
- Previous message: Learner: "What is meant by 'Changing fact-table attributes'?"
- In reply to: Dennis Redfield: "Re: OLAP (Analisys Services) from .NET for WebPages"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 1 Apr 2004 09:02:30 -0800
what are the database roles, is it still everyone?
I've been able to connect through .net.
>-----Original Message-----
>perhaps Database FoodMart don't exist
>"george" <anonymous@discussions.microsoft.com> wrote in
message
>news:225A190D-226C-455A-A9D9-
50B1EAA782FF@microsoft.com...
>> Hi
>>
>> I want to connect to Analisys Services Database
from .NET on C#
>>
>> I'm try this simple example
>>
>> DataSet myDS;
>> myDS = new DataSet();
>> string ConnStr;
>> ConnStr ="Provider=MSOLAP;Password=sa;Persist Security
Info=True;User
>ID=sa;Data Source=TAMLCS2;Initial Catalog=FoodMart
2000;";
>> string SQLSelect;
>> SQLSelect = "with member [Measures].[Store Profit
Rate] as
>'([Measures].[Store Sales]-[Measures].[Store Cost])/
[Measures].[Store
>Cost]', format = '#.00%' select {[Measures].[Store
Cost],[Measures].[Store
>Sales],[Measures].[Store Profit Rate]} on columns,Order
([Product].[Product
>Department].members, [Measures].[Store Profit Rate],
BDESC) on rows from
>Sales where ([Time].[1997])";
>> System.Data.OleDb.OleDbConnection mySqlConn;
>> mySqlConn = new System.Data.OleDb.OleDbConnection
(ConnStr);
>> mySqlConn.Open();
>> System.Data.OleDb.OleDbDataAdapter mySqlDA;
>> mySqlDA = new System.Data.OleDb.OleDbDataAdapter
(SQLSelect,ConnStr);
>> mySqlDA.Fill(myDS);
>> MyGrid.DataSource = myDS.Tables[0].DefaultView;
>> MyGrid.DataBind();
>>
>> The error message is : Database FoodMart don't exist
in line :
>mySqlConn.Open
>>
>> I've install on server: SQL Server 2000 sp3, Analisys
Services sp3 y
>Visual Studios .NET 2000 with Framework 1.1
>>
>> somebody have a idea?
>>
>> thanks
>
>
>.
>
- Next message: Jón Sveinsson: "How to create install scripts to import olap cubes"
- Previous message: Learner: "What is meant by 'Changing fact-table attributes'?"
- In reply to: Dennis Redfield: "Re: OLAP (Analisys Services) from .NET for WebPages"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
