Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AlbertoNF
Starting Member
5 Posts |
 Posted - 2012-04-23 : 05:18:01
|
| Hi, my name is Alberto and I am a Powerbuilder/SQL Server Junior Programmer.I need you to help me with this:I have an app developed in Powerbuilder 12.0. I want this app to conect with SQL Analysis Services so I can retrieve cubes. My problem is I do not know how to link them. Is there an OLE control and API to handle it?Thx a lot.Regards,Alberto |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-04-23 : 07:08:15
|
| There is an OLE DB provider you can install. Search for "Analysis Services OLE DB Provider" in this page (ctrl + f): http://www.microsoft.com/download/en/details.aspx?id=16978- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
 |
|
|
AlbertoNF
Starting Member
5 Posts |
Posted - 2012-04-25 : 03:47:42
|
| Yes, I have that OLE provider installed in my server, but I do not know how to deal with it. Is there an API to see how to use it? classes... functions... etcThx!!! |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-04-25 : 04:45:55
|
| I know very little about this but what is it you want to do? What one would normally do when connecting to an external data source is to establish the connection using some kind of connection string (http://www.connectionstrings.com/olap-analysis-services) and then write a query to run against the data source. The query would in this case have to be MDX since SSAS is a multidimensional data source. That's about all I know.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
AlbertoNF
Starting Member
5 Posts |
Posted - 2012-04-25 : 06:55:28
|
| What I want is an object to store the retrieved data, and I do not know what kind of object can store multidimensional data in Powerbuilder...I need to connect to Analysis Services with a connection string, aham, but the query and where to store the data is what I do not know... :( |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-04-25 : 07:11:56
|
| You would probably be better off in a Powerbuilder forum.- LumbagoMy blog-> http://thefirstsql.com/2011/07/08/how-to-find-gaps-in-identity-columns-at-the-speed-of-light/ |
|
|
|
AlbertoNF
Starting Member
5 Posts |
Posted - 2012-04-27 : 05:48:56
|
| Thx for your time, Lumbago.Anyone else can help me, please? |
|
|
|
AlbertoNF
Starting Member
5 Posts |
Posted - 2012-05-08 : 02:54:25
|
| Does anyone know how to do this? |
|
|
|
|
|
|
Analysis Services in Powerbuilder