Recent content by Swathi37

Thanks a lot Steve for your response !!! I finally could get a workaround for my issue. I found that I had to declare individual dimensions like Quarters and Months in my powerplay cube so that it is not broken down again by 2005 Q1, 2005Q2 etc and then publish that cube for creating reports on...

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, Does anyone has any workaround for this problem? Please help!! Thanks Swathi

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

Thanks DoubleD!!! The mdb database is on the server. But when I try to open that I get the readonly message and I can't open that. Could you please provide me few steps as to how to go about this process. 1) Created DSN on the server with the name IWRAudit. 2) The mdb file is on the server. How...

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

Wow!!! Thank you so much!!!

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

Thank you so much for your help.

Thanks so much for your response. DoubleD, Could you please explain this process in detail?

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

Thank you Sharat. I will try and let you know.