Search results for query: *

My other issue for the day: When I try to add a new item to the scheduler (in this case it is an impromptu report), I am getting the following (unbelievably helpful) error message: Error Number: -2147417851 Error Description: Automation error. The server threw an exception. OK This error...

Hi Everyone, I have a very weird Impromptu problem. I can open and run reports on Impromptu (User or Admin) v 7.1.724.0, but when I go to close the application (either by clicking on the X to close the app, or by choosing file--> exit), I have to do it twice to close off the app. So, if I...

I'm trying to apply conditional formatting to a crosstab in reportnet. My crosstab is employees by days, with the daily load rate (ie 0 - 1 formatted as a percentage) as the measure. I have a conditional variable (string) called allocation, defined as follows: case when load > 1 then...

I have a reportnet report with conditional formatting. I have a boolean variable, where if the actual >= target a red icon is displayed, otherwise a green icon is displayed. When I hard code the value in the variable expression as Actual >= 40 the conditional formatting works correctly...

The problem: I have a simple list report that contains two attribute columns, and a measure column. I want the user to be able to select if they want to hide or show one of the attribute columns in the report via a checkbox list prompt. For the purpose of keeping this example simple, assume...

Hi, I've come across a weird problem since our upgrade to Cognos Series 7 Version 3. When I publish a PowerPlay cube to Upfront (from the PPES software installed on the PPES machine), it works fine. I can then access the cube and reports through upfront for the rest of the day. Then, the...

Hi, I have a cube that includes the organizational structure as a dimension. Im using the cost centre code (eg. 12345) as the source value for the category, and using the cost centre code and the cost centre description (calculated in the IMR report eg. 12345 - Accounting). Now, in the source...

I realise this has probably already been answered here several times before, but because the search functionality isnt working at the moment, i cant find the answer. I have an impromptu catalog, and i want to change the the database that the catalog is pointing to, as we moved the DB to a new...

Hi, I have a report that has 5 lists. The first list is being sourced from the employee master table, and the other 4 lists are being sourced from tables that contain employee measures. The report is run with an employee number prompt, and the parameter from this prompt is what links the...

I'm opening an impromptu report on my computer (Impadmin v 7.1.339.0 on Win2K) and the catalog logon window is coming up. The user class selected is 'Creator' (the password box is empty and greyed out), and the 'Connect to the database' option is selected by default (and the userid and password...

Hi, I have my metrics manager application setup with a scorecard for each employee (Scorecard identifier is the employee number). When you view a metric from a scorecard, you go to the metric "History" tab. In the "Reports" tab, I'd like to link to a ReportNet report. I understand how to do...

Hi, I've setup a drill through from my PowerPlay cube to a ReportNet report containing sections (a section for each year -> this is the parameter that im passing through). The drill through itself works fine and the correct data is returned, but if I attempt to view the drill through report...

Hi, I'm trying to modify an impromptu catalog, but when i open the catalog in impromptu admin, I cannot view any of the options from the 'Catalog' menu (ie. Tables, Properties, Folders, User Profiles, Joins etc). Does anyone know what causes this? J

Help!! Im losing my mind In my transformer model, im reading a field that is stored in the SQL database as a decimal(5,2). For example, 9.09 I want this value to appear in my cube as 9.09% (ie, formatted as a percent with 2 decimal places shown). I'm guessing that transformer is expecting my...

Hi Everyone. Does anyone know how to PERMANENTLY switch off automatic indentation in PowerPlay client? When I view a cube listing a dimension down the left side of the report and the dimension list contains around 30 categories, it indents the last 10 or so categories, which is really...

I've just installed Framework Manager on a new PC, and i'm having some problems connecting to any of the data sources that are defined in ReportNet. When I go to create a new project in framework manager, the wizard comes up, I select the language to create the project in, select the import...

Hi, I'm trying to build a ReportNet framework, and I need to create a query subject based on a manually typed SQL statement. The problem I have is that my SQL statement contains multiple MINUS clauses to remove many subsets of unrequired data from the main query. The query works when I...

Hi, I have a ReportNet report with the report run time in the header. When I run the report, the time being displayed is an hour behind what the time really is (eg. its displaying 11:59AM when its 12:58PM). This problem is occurring for all users, and each of these users have their time zone...

Hi, Here's my problem (sorry its so long!): I want to create a staff birthday list in ReportNet that simply includes the month name, and the names of staff who have their birthday in the month. I want the report grouped and sorted by month only (in calendar order). ie. MONTH STAFFNAME...

Hi, Has anyone out there done anything neat with the PPES audit logs? I'm looking at building an audit cube from the data and I'd heard that Cognos were looking at providing some sort of utility to process the data, but I dont know too much about it. Can anyone bring me up to date? J