Search results for query: *

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.

Gary, I tried the same logic. The logic works fine if I use Service and internal columns in the filter. If I calculate by grouping them, it gives me zero. Please advice. Swathi

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

Sudhi, Yes, That is correct. Please advice. Thanks Swathi

Raj I tried publishing the missing report seperately and it works. But I cant publish the whole reportset. Please advice. Thanks Swathi

Gary, Thank you for your response. Smarthotfiles are the imr reports that I use as a datasource in another imr report and all of these reports use a single catalog and it is located in the same folder along with the other reports. How do I solve this issue? Please advice. Thanks Swathi