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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: bebbo1986
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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
  8. 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...
  9. 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"...
  10. bebbo1986

    Return Array from Function

    Hello, I wrote this programm which tries to use the Function MatrixVektor. PROGRAM MAIN REAL, DIMENSION(3) :: v REAL, DIMENSION(3) :: w REAL, DIMENSION(3,3) :: A ... filling v and A w = MatrixVektor(A, v, w) END PROGRAMM FUNCTION MatrixVektor(A, v) REAL, DIMENSION(3)...
  11. bebbo1986

    Change Cube

    Hallo, I open a PowerPlay (version 7.3) report via VBA and now I ask myself is the a chance to change the cube from with the report gets his data. There exists the property PowerPlayRep.CubeName but this is only for reading and not for writing. But I need exactly this method for writing. Of...
  12. bebbo1986

    ShortName in macro

    Hallo, I have one short question. In my macro I want to refer to the short names in the background. Is there any command like: Dim longName As String Dim shortName As String shortName = obj.Item(longName).ShortName Thanks for any help.
  13. bebbo1986

    Copy specfic Layer with macro

    Hallo, I use VBA to control cognos and then copy the report in Excel. Everything is working very well so far. But now I have different layers and want to copy the values from a specific layer. When I write: PowerPlayReport.Copy always the first layer is copied. This won't work...
  14. bebbo1986

    Export Report via CognosScript

    Hallo, I have managed to control the dimensionline of my report with a macro. Now I want to export the resulting report in one Excel-worksheet. Then I want to change the dimensionline again and export the report with the new values in the same workbook in a further worksheet. I've tried the...
  15. bebbo1986

    Creating report via macro

    Hallo, I'm using Cognos PowerPlay 7.3 and I'm not yet an expert. But it's getting better. Now I need to create a report via macro (*.mac). And I heard the macros are related to VB and this programming language I know. My questions: Is these possible? How are the commands for creating a report...

Part and Inventory Search

Back
Top