Search results for query: *

Hi All, I have a cube with 3 time dimensions and most of the analysis is done between time dimensions (say order_date and shipment_date) While drilling into details, it becomes very confusing to keep track of the categories in these dimensions(2003 Q1 : is it order_date or shipment_date). The...

Verify the path for target Newsbox in the 'Cube Drill Through' property

Hi All, I would like to know if anyone is using VSS with any of the Cognos components. If yes, then could you please give a brief overview for what component and what purpose? Thanks

We have a accumulating fact table with the different calculated measures showing the time duration between different phases. All the different phases should appear as different categories of a dimension. This could have been simpler if the grain of fact table was at a phase level. BUt in these...

My system [Pentium 111, 550 MHz, running windows XP Pro(Upgraded from Windows 98SE), having 2 hard drives C & D and one CD ROM drive] is infected with adware/spyware. After running anti spyware programs i.e spybot, adware and Spy Eliminator, no spyware was reported by these utilities. When I...

Hi Nagrajm: Can we also use the running count for our situation. Right now, we use category count on Case_id in a similar manner as in this problem. We are trying to build a cube with data from two tables sharing Master-Detail relationship. The master table stores the static information like...

Thanks Denny. As I am novice in Cognos, would you please elaborate how to use running month(is it a function in Impromptu ?)in the Report Query. We are adding a record for intermediate months at database level and doing this at Impromptu will save us a lot of time and effort. Thanks in advance...

Hi All, We are trying to build a cube with data from two tables sharing Master-Detail relationship. The master table stores the static information like Case_type, Received_date etc. about 'Cases' which go through different phases. The changes in the phase along with Date_Phase_change are stored...

It works. Thanks a ton Dave

Hi All, I am creating a report containing nested grouped data which the user then saves as 'Excel with Format' file. The problem is as the Grouped field is not repeated, there are blank cells for the column corresponding to outer group. What can be done to repeat the grouped data values in...