Search results for query: *

I cannot answer your first question accurately, as I'm unfamiliar with MySQL and PHP. As to your second question. Cognos does charge a license fee per named user. If you're purchasing PPES (since you're talking about web) you normally get a number of licenses included in the cost of the...

I should also add, that this is the second instance of sql server on a the server.

Has anyone seen or resolved the following problem. Cognos support is dishing it off saying its not thier fault microsoft's odbc driver does not work. odbc driver for sql server version 2000.81.9031.14 (ships with sql server 2000 sp3) what's happening is that my table has a numeric(10,2)...

Yes, there is a percent of base calculation that you can use in your report. For example if you click on a column that represents both a date and the number of incidents, clicking the calculate menu should show a "percent of base" calculation. Select it and choose "Total&quot...

There is very little third party documentation on cognos products. The only book I've ever seen online is "Impromptu Startup" by Brian Olah. I cannot recommend it as I've never seen the book in the flesh. If you can get your hands on the boxes that the software shipped in, there are...

You should be able to change the text of the ms-word docunment with the embedded images option, as long as the text is not in the powerplay reports On our PowerPoint app, I left spots in the slides for comments to be inserted into the reports. However there was manual intervention, someone had...

Are you using a .bat file that calls cognos macros? If so you could use the PowerPlay Admin Tool which gives you the flexability of disconnecting individual cubes. Otherwise from your batch you could do a net stop "PowerPlay Enterprise Server (cer3)" to disable all cubes before you...

I've done similar work to load powerplay graphs into PowerPoint documents. What we did was build two macros: Macro #1 in powerplay to save the appropriate reports out to .jpg files Macro #2 in PowerPoint to import the images into the PowerPoint document, and apply formatting to it. It...

I've done a number of large scale banking and insurance implementations, and PowerPlay has had similar "in seconds" performance to what your salesrep has indicated. Your sales rep should have done a demo showing a pyramid of degree of summarization. PowerPlay works well for...

From an oversimplified perspective what you need to do are: - requirements gathering, what are you trying to achieve - dimensional modelling (often through a JAD session), how to people organize the dimensions and measures that they want to view? Is that data available - develop a logical cube...

You should be able to select multiple values using a regular catalogue picklist The way to do this is, in your Prompt Manager you must choose "data" in ("prompt picklist") rather than "data" = "prompt picklist" where "data" is the field in...

There are limits on much much box you can throw at Transformer. Typically multiple processors are used to read data into the model (ensure enable multi-processing is checked on the properties of your data sources with >100000 records) The physical cube build only uses one processor. There's...

Hi Everyone: This is probably easy to do, but I'm looking for syntax to end the pwrplay.exe process from the command line. My DOS skills are not that great. Basically I have a number of cognos macros, that despite all objects being set to nothing at terminiation are still leaking memory. I'm...

Oh, I fixed my own problem. ActiveWindow.LargeScroll Down:=2 ActiveWindow.View.GotoSlide Index:=2 ActiveWindow.Selection.SlideRange.Shapes.AddPicture(FileName:="E:\Reports\Business_Solution\OTIS\Images\OTIS_NOIbyMonthGraphgraph1.jpg", LinkToFile:=msoFalse...

Hello: I'm trying to write a macro script that will insert an image into slide #2 of a powerpoint presentation. I can write one no problem that drops images into slide #1. The problem I seem to be having is accessing the method or property setting for slides other than slide #1. With...

I have not seen your exact problem, but I have seen problems where the report looks one way in Impromptu admin and a different way in IWR. In my case Impromptu Admin was on a different server. When IWR renders a report as a .pdf it uses the printer driver set as its default. To ensure that...

You should always save an mdl file of any model that you're working on. They make excellent backups. Do you have a log file? It may hold a clue to your crash. How many rows of data are you processing. By default it should write to your program files/cognos/cer2/bin/ directory. It might be...

In Impromptu you should just have to do a: left(monthname(date_value), 3) where left is the left function, monthname is the monthname function, date_value is your date field, and 3 is the numeral passed as part of the left arguement. That worked for me against a SQL Server db. -Charles

Here's a solution to A) opening the model Do you have a .mdl file saved as a backup? If so, reboot the server. Go into your temp directories that you build your cubes in. Either your batch script that builds the cubes specifies this, or you can see this in files/preferences from transformer...

unless its the funky corporate firewall i'm sandbagged behind. Its wierd though, I can receive from anyone, but only send to my coworkers (a different company), but I cannot even email the corporate people I report to. nobody here really knows anything about the firewall, and I'm in the IT dept.