Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bebbo1986

    Cube-Operator exisiting

    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.
  2. bebbo1986

    Cube-Operator exisiting

    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...
  3. bebbo1986

    Enter connection string

    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...
  4. bebbo1986

    ODBC connection to SSAS

    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.
  5. bebbo1986

    ODBC connection to SSAS

    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...
  6. bebbo1986

    Connection problem with Analysis Services

    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...
  7. bebbo1986

    Fehlende Berichte

    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.
  8. bebbo1986

    Fehlende Berichte

    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...
  9. bebbo1986

    Fehlende Berichte

    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...
  10. bebbo1986

    SAP Interactive Excel

    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...
  11. bebbo1986

    Using cmd and Named Pipes

    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.
  12. bebbo1986

    Performance Problem from SSAS

    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.
  13. bebbo1986

    Using cmd and Named Pipes

    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...
  14. bebbo1986

    Using cmd and Named Pipes

    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
  15. bebbo1986

    Performance Problem from SSAS

    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...
  16. bebbo1986

    Performance Problem from SSAS

    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...
  17. bebbo1986

    Performance Problem from SSAS

    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...
  18. bebbo1986

    Changing Cube

    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"...
  19. bebbo1986

    Return Array from Function

    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?
  20. bebbo1986

    Return Array from 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.

Part and Inventory Search

Back
Top