Search results for query: *

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 ?

Hello Gurus ! I have a date field in my database that gives me the month and year. I have to calculate the number of weeks for the respective months using this. Can anyone help me with this please. Thanks, D

Thanks Jochen, this was useful - am now trying to get a solution to counting the number of 'Y' in a column with boolean values. I have abt 4 of cols in my table with such values, and have to find the count of 'Y'-s only in e4ach of the cols. Would really help if you cld help me with this. -...

Hi Gurus ! I need to calculate YTD revenue in the Framework Mgr. Would any one have the formule for the same. Thank you, Damini

Hi guys - now this looks tricky to me. Am trying to get the row count of my list report and insert that into the page header of my report. Could anyone help me with this. Am working in Report Studio in Reportnet. Thanks so much. - Damini

Hi Gurus - I am trying to bring in data from 2 unrelated queries into my report. One is in the List Frame - which is eay. The other Query is to create the Report Header. Is there a way I can create a second query in the same report for the Report Header information. Any help is appreciated...