Recent content by damzi

Hello Cognos Gurus, Here is the data that I am looking to model in Cognos Transformer... ColumnDate ColumnTRS ColumnLMN RevenueX RevenueY A Calculate* 201601 B Telltale 10 20 201603 B Fixit 10 20 201602 B...

I am trying to interface 3rd party tool - in my case Excel reports with the Cognos Reportnet reporting. I have a bunch of users who have their selection criteria in a complex web of excel formats - these are interconnected to be able to find connected criteria in another excel sheet. I am...

Hello my Reportnet geeks, I am trying to find a solution to reporting on multiple tree structures used in the Financial Journal Ledgers using the nodes. This is to do a Journal Listing kind of report. While using the Powerplay cubes this solution comes easy, I am looking to do this in the...

Hello, I am looking for a way to convert currency in some financial reports in Reportnet. The catch here is that I have to do the conversions before the rollups in Framework Manager. Is it feasible to convert currency in FM? Could any one suggest a solution for this? Look forward to your support...

How may I set up auditing in Reportnet for report and databasse and table usage by the users and user groups ? Will welcome any cues are welcome.

Thanks so much for your input. Is there any solution to running these in excel on the web without the performance issues due to the html output. Like conversion to the binary as the report is running. Am also trying to find a solution to report performance in reportnet. It seems that the...

I am facing performance issues while trying to run my reports in the excel format in Reportnet. It seems that it is because the report runs in the underlying xml format and not in the native excel format. Even if scheduled and saved in Excel, the reports take an inadvertantly long time to run...

I have this file of abt 26 megs in excel that is saved frm Reportnet. It takes abt an hour to open on my PC. Yet another excel file of about 57 mgs - not created in Reportnet takes just a few seconds to open. Does anyone know why; and if we have a solution to this. Is this a known issue in...

yes - u guys are right. It worked ! thanks so much. - Damzi

In my report I have 2 optional prompts 1 and 2, either of which has to be selected. I want one of my columns to be visible when prompt 1 is used in the report, and not visible when prompt 2 is used. I am unbale to find the toggle to the visible property on the same. Does any one has any ideas on...

In one of my reports I have to use images, that are placed in the webcontent folder of the Application server. The images are named accoring to the ItemNo (one of the columns in my report) followed by the standard characters 'ln.jpg'. How can i use the images corresponding to the respective...

Hi, In one of my columns in a Reportnet report, i have to bring in the diffrence between today's date and 2 yrs frm now - so how can i calculate the difference between the 2 ? Any ideas ? D

Hi Friends - I need some urgent help with this. The YTD calculation I have used in the FrameWork Manager to use is my reports is as below, total(If(year( [SanfordDW].[Date].[Date] )=year(current_date) and [SanfordDW].[Date].[Date] <= current_date) then ([SanfordDW].[POSMonthly].[QtySold] )...

Hi Guys - am trying to find the number of days between a beginning and an end date. is there a painless way of logic for the same ? This is for report development in Reportnet. Hey wld appreciate a fast response...

I mind sound silly - but what wld be the difference in the two ?