Advertisement

Experts have come up with some helpful tips for getting a solution to your problem fast.

 

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

 
Time Tested Cognos PowerPlay Solutions: 1 - 25 of 30
 
Hi can anyone give an example of a cognos crosstab report please? although i have listed this as powerplay I am actually using cognos8 Thanks
Any Cognos experts??  If so, I am working with a client. We have extracted certain time intervals in seonds and are using these intervals in our cubes. The problem is that when the client is a...
After installing Cognos Power Play 7.3 on a machine with Windows XP Professional English Service Pack 2 and MS Excel 2003 English SP 3 (MS Office Small Business Edition) and installing Power P...
Hi I have created a prompt report. Can anyone tell me if this can now be scheduled to run at specific times or if not can it be run manually and emailed to a receipient? Thanks Adam
Hi Are there any cognos experts that can tell me how to create a datetime variable in Cognos 8 Thanks
Hi Experts, I would like to access a sql server which is not in our domain via Cognos 8 Framework manager . 1) which ports do I need to open for the firewall? 2) how does framework manager ...
I just completed installing Cognos 8 Web/Application server (roles: dispatcher, content manager). Opened Cognos Configuration and Selected Action menu and clicked Test. Got the below err...
Hi, Can anyone give me some documentation on how to create reports using cognos 8? I am pulling my hair out tying to create a list report containing data from two seperate queries!
Hi Guyz, I've got a problem in my Cognos Powerplay Transformer Cube. One of the measures in the cube is ActualYTD which returns the actual gross sales values for all the years, and month...
Hi Experts, I have different models in two different frameworkmanager-files. The collegues in the U.S. have their own model, and we have one here in Europe. Now the U.S. needs to have part...
Hello, Can someone tell me how Report Output Versions are stored in Cognos 8.3?  Does it store these files somewhere on the app server or in the content store?  It doesn't seem to access th...
I created a time dimension using the Date Wizard in Transformer. However I need to create a custom time level that displays the dates for the previous 12 months relative to todays date. How do...
My company new using 2 different version to generating Powercube with transform - TRNSFRMR command. My db (dbase) totally have 270 columns. it is okie if I using transformer 6.5 to create p...
Cognos PowerPlay 7.3 runs on a machine with Windows XP Professional English Service Pack 2 and MS Excel 2003 English SP 3 (MS Office Small Business Edition). When copying more complex cubes u...
Hi with reference to cognos8 can anyone tell be the difference between a drill down report and a cascade report? cheers
Hi Using cognos8 is it possible to calculte figures figures together from queries that are not joined for example query 1 counts employees query 2 to counts cases I want to find...
I have basically had no training with Cognos and I'm now having to edit a report. My report displays how many types of visits a provider has made during a period of time.  That works great....
Hi I have been advised by a cognos expert that it is a good idea to back up the xml documents that make up the cognos fm model. Can anyone tell me how to do this please? Adam
Hi can anyone tell me the purpose of the (Brackets) in the following statement please if (?IndustryGroup? ='None') then (null) else ( if ([Relational View].[Industry].[IndustryGroup]=...
We have recently upgraded from IE6 to IE7. On IE6 menus in Cognos 7 (Web-based) menus cascade but on IE7 they do not. Anyone know where I should start to look?  I've added webpage to Inter...
I'm doing another variation on a report I've been working on and I've run into a seemly simple problem that I can't resolve fast enough. So.  As you can see in the screenshot, I have 2 date...
Im using cognos 8, I hav a situation in which i hav 2 facts and one bridge dim, this bridge dim has i to many relation with on fact but 1 ..1 with another fact tht makes is ambiguous, how to s...
Does anyone know of a way to facilitate a live cube swap without having to bring the PowerPlayEnterprise Service down first.  We have cubes that refresh every hour and need to swap out these c...
I made a prompt to get the values for one query subject....e.g. time line....my query subject has 3 items...time line , startdate , enddate....as the time line is displayed to the user in the ...
We backup a Cognos server using Backup Exec and frequently there are files with a .pyi extension that get skipped during backup.  My understanding is that a .pyi file is a compiled version of ...