Search results for query: *

Hi all, I can build time dimension in Tranformer using date wizard. The time dimesions are year, quarter, month... when you generate categories year would be 2005 and 2006, quarter would be Q1 2005, Q2 2005, Q3 2005 , Q4 2005, Q1 2006, Q2 2006, Q3 2006 , Q4 2006. If I need to create a crosstab...

Hi All, I am a newbie in Report Studio. I am having toughtime bringing in the subtotals and grand total in a simple nested crosstab report. The data with the report looks like the following. Cnt of ProdID ABC PQR TOTAL 2005...

Hi All, I need your help! I tried running the reports on the upfront by going to action and run and save the report. I don't get to see the round small icon right below the report that shows the report is running. When I go to server admin, I see the report is in the queue. Why is that I don't...

Hi all, I have issues collecting the audit information from the server on to the Access database. I created the DSN on the server, scheduled the collect audit data on hourly basis and also configured the access manager. What am I missing? Should the mdb, the catalog and the impromptu reports...

Hi All, I have a problem automating the report process. How do I automate the Cognos report with the following running schedules. I have an imr report which should give me the report from say Aug 1st to Aug 15th when I run this report on 16th Aug. When the same report runs on Sep 1st it should...

Hi All, I have a quick question. When I try saving the cognos report as Excel in IWR, it saves it in Excel 95 format and as a result, if the report has 20,000 rows, it creates 2 sheet tabs dividing it by 16,000 in sheet1 and 4000 in sheet 2. How can we get all the rows displayed on one single...

Hi All, I have a question on extracting the top n number of rows say top 100 rows from a report using Cognos Impromptu. Ex: The report has Customer# #ofUsers --------------------- 123 100 298 89 471 70 288 53 500 8 If I have to pull...

Hi All, I have a problem running a report that uses hotfiles on IWR. I have about 6 hotfiles. I schedule each hotfile report to run sequentially and the final report that uses the last hotfile does not run. When I check back on the server, all the 6 hotfiles did run along with the final report...

Hi All, There is no median function in cognos. How to calculate median for total hours. For ex: This is the data Internal Service Minutes I BPP 250 I BPP 120 T BPP 20 I BPP 320 T BPP 420...

Hi All, I have this weird problem. I have a reportset with about 10 imr reports and there are couple of smarthotfiles too. When I tried publishing this report set to upfront, I get the error 'Publish Failed'. But I could see 9 reports out of 10 published on upfront. I tried publishing another...

Hi All, Is there a way to get the Report titles on to Excel from Impromptu Report? If I export the imr report to Excel with format, only the detail report gets exported. I would like to have atleast a line describing the name of the report. Because my clients are interested only in Excel...

Hi, I need to calculate percentages from two different list reports. I use 2 tables Customertable and customerlogintable. Link is based on custID. Listreport 1 COunt of Customers who are Externalcustomers External -------- 250 Calculation: Count(CustID) filter: ProdID='ABC' Note: I use only...

Hi, I have a question. Is it possible to run Access queries by using a macro and using the output table in Impromptu report. What would be the macro to run access queries. Thanks in advance. Swathi.

Hi All I have a question regarding Macro. Is it possible to run 8 .imr reports by using a single macro and save it as a .csv file. Each report has more than a million records that needs to be converted to csv file. Do you have the code? Thanks for your help Regards Swathi.

TNum TDesc Count(TSubtype)[June-03] Count(TSubtype)[May-03] Increase/Dec %ofIncrease ---------------------------------------------------------------------------------------------------- 1 Pay 158 100 58 2 Invoice 2000 1900 100 3 Returns 30 20 10 Calculations for...

Hi, I have a question. I have crosstab query that looks something like this Service E I O D T ABC 45 8 8 6 9 PQR 34 3 2 3 XYZ 12 2 3 4 Services are ABC, PQR and XYZ InternalTest = E,I,O,D,T...

Hi all I have serious problem with the hotfile. I had created an imr report using a hot file. But my report runs very slow since the hot file is 1GB. I would like to use an MS-Access table instead of hot file. So how do I delete the hotfile and include the MS-Access Table in the already created...

Hi, I have a question in Access. CustID A# Type ------------------------------ 0023 20 AB 0023 21 WI 0021 09 WI 0034 10 AB 0044 12 AB 0044 29 WI My question is If CustID has both AB and WI as Type I need to extract AB type custIDs, but if the custID...

Hi, I have a question in Access. CustID A# Type ------------------------------ 0023 20 AB 0023 21 WI 0021 09 WI 0034 10 AB 0044 12 AB 0044 29 WI My question is If CustID has both AB and WI as Type I need to extract AB type custIDs, but if the custID has no AB but only WI I need to extract...

Hi All I have a question. I created 2 crosstab queries 1)Crosstab for number of logons per Customer per account per day. Crosstab Format for Logons -------------------------- CustID Acct# 1-Mar 2-Mar 3-Mar 4-Mar 001 1234 34 44 91 44 002 1989 9 8 77 98 003 9871 29 9 91 98 2)...