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.

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...

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...

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

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...

Hi - I am trying to find the URLs of the reports in Report Studio in order to use them as hyperlinks. I do not get these in the properties of the reports. Cld you please tell me where to find the URLs - thanks !

Hello Gurus ! Would any one know how to edit XML for a report in Reportnet. When I click the XML tab I get a window where I cannot copy or edit the code. Does any one here know if this can be done and how. Thank you !

I am seeking a solution to connecting a high-level reports with low-level (detail) reports in Reportnet. I can not and do not need the drill-through as these are not filtered - the high-level report needs to connect to different detail reports, depending on the row. One way to be to connect with...

Hi - I dont see the contents of my deployment archive in the cognos connection. Have rechecked the configuration manager for the path as well as the contents of the same in the explorer. I have just pasted the contents in the deploymant archive. Why do I not see it in Cognos connection. the...