Search results for query: *

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

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

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

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

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

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

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

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.

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

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

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