Search results for query: *

In fact there exists some database systems that can use the cube operator in their SQL version. For example with MS SQL Server in the corresponding T-SQL.

Hallo together, I have one short question. Is in PostgreSQL something like a CUBE-Operator existing. According to the manual there is nothing. But perhaps I didn't find it. If not, what would be the best solution to get the same result. Probably a lot of GROUP BY in combination with UNION...

Hallo together, I want to access Microsoft SQL Server Analysis Services 2008 from PROLOG. For the SQL Server it is no problem because I can establish an odbc connection and send SQL commands over this and receive the results. But for Analysis Services I can not use ODBC. How could I communicate...

Thanks for your answer. Until now it doesn't help me. Because the fact is I want to connect to SSAS from PROLOG and there I haven't got the possibility to use such connections strings, but to connect directly to an odbc connection. But I will check this in the PROLOG forum. Thank you so far.

Hallo together, I want to send an MDX query over ODBC or OLEDB to Analysis Services 2008. Is this possible. To the normal database engine I can connect via ODBC and send SQL queries. But there are no command like 'use CubeName;' and it is not possible to send MDX via this connection, right...

Hallo together, I'm using a separat PC in the network as a kind of test server and installed SQL Server 2005 on it. And there I established a cube with SQL Server Analysis Services. From my PC and with my account I have rights to read and write on this PC and with \\c161FI005\c$ I can open the C...

Thanks for your answer. I think that can really help me. And I'm already in two SAP forums but not in the SAP Community Network, I think. I will join it. First of all I have no particular data in mind. There are a lot of reports and therefore a lot of different data needed.

First of all thanks for your suggestions. I'm normally programming in Visual Basic but probably I could learn something about ABAP. But more interesting I find the things about Query reports. As a matter of fact I haven't got authorisation to create queries. But perhaps I can get it. What can...

Hey together, I have a the following problem. In my company SAP is working for three months and there are needed some reports that have not be prepared, by the SAP team. Now I'm searching for a way to get these reports without paying a lot of money for the SAP team to create these reports...

Hallo together, I want to use the Excel-Addin "SAP Interactive Excel" which was delivered with our SAP. Because I want to create some reports with it. But I have no idea how to do it. Is there some kind of tutorial for it? You can I for example extract receivables out of the SAP. Because I want...

I solved this problem. I had to change the properties of the server. I had to set "Advanced > Filestream Access Level" to Full access enabled. Now I have to check out how to work with the results. I think there will be new problems. We will see.

As I said. I have no direct access to the server. I can only try to get the maximum out of the excel add-in. But you are of course right. So I posted in the wrong forum. Should not happen again. Sorry.

Thank you very much, you really helped me. But there are already the next problems. I created a new alias with the name: VAIONamed and Parameters are \\BEBBO-VAIO\pipe\sql\query I tried: sqlcmd -S np:\\BEBBO-VAIO\pipe\sql\query and sqlcmd -S np:VAIONamed both led to errors like: Could not open...

Hallo, I need a method to access SQL Server (Developer Edition) via cmd and Named Pipes. Is it possible do connect to the Server via cmd, send an SQL command and catch the result to go on working with it. Thanks for any help, Martin

My solutions was now separate data import and using the data. The link between is done with an vba macro. So I import the data, take it and copy it to the sheet where the caculation is done. But another solution could have been a stored procedure in the SQL server to pre-select the data on the...

Oh sorry I forgot to tell: I only have access via network to a specific cube and so I cannot influence MDXs, can I? Because I have no access to SQL Server itsself. And there is not much that can be precalculated. I need all these figures in my excel sheet. And sorry I don't know what DSV means...

Hallo, I'm using SQL Server 2008 and Excel 2002 the Add-in for SQL Server Analysis Service. I want to import a lot of data via a structured report and then use this data in the same excel file with VLOOKUP. And there are a lot of VLOOKUPs and it seems to calculated after every cell that is...

Hallo, I'm using SQL Server 2008 and Excel 2002 the Add-in for SQL Server Analysis Service. On my Server there are different Cube, in every Cube there is a dimension called Dealer with a hierachy "Total Dealers" with an entry "All". What is now different in every Cube are the children of "All"...

Your right that helps with the problem. But that was also the reason, why I had (A, v, w) in the text before. Because I tried that already and of course it helps. But why can't it be done via function?

Thanks for your answer. I tried as you suggested but the problem stayed the same. The function should deliver the product of the matrix A with the vector v. I think it should work with SUM(A(i,1:3)*v) because it's the same only in short.