Search results for query: *

Hi, We have a report in the Report Studio which is running fine and giving the correct data. The problem is that the execution time varies from 10 sec to 10 minutes for the same prompt selection and data. What could be the reason for the same. Please treat this as Urgent Regards, Vish

Hi, We are working on around 1800+ Cubes which are refreshed by a single model. These Cubes are refreshed on a periodic basis via command line. Going forward, we wish to convert the cube groups based on User Class rather than categories. The problem is that even though we can initiate the cube...

Hi all, We are trying to Recieve data from msmq triggers through a DTS package. In our Scenarion, we pour data in the messaging queue from a Stored Procedure. The requirement is to get the data from the queue in the warehouse on the real time basis. We have been trying using the MSMQ Triggers...

Hi, We are facing the following problems in the IWR: 1. We are not getting the Drill Through Option when we run the report. Tried both in Excel as well as PDF. 2. There are 3 sub reports in the IWR excluding the main report. we need to drill through from Sub Report 2 to Sub Report 3... Is it...

Hi, We are in the process of creating a new Data Warehouse on SQL Server and Cognos Suite 7. The DW has to be Real Time with the least possible performance issues. What i want to know is: 1. Can Cognos support Real Time DW ETL by DS or is DTS is the better option (Data Size is 100GB)? 2. What...

Hi, We are in the process of creating a new Data Warehouse on SQL Server and Cognos Suite 7. The DW has to be Real Time with the least possible performance issues. What i want to know is: 1. Can Cognos support Real Time DW ETL by DS or is DTS is the better option (Data Size is 100GB)? 2. What...

Hi, We are having our Facts and Dimension delivery from Decision Stream 6.5. The problem is it is taking long time to deliver. For a row size of 22000, it is taking 30 minutes. The same row size when done with SQL Server DTS, takes 5 minutes. Can any one tell what may be the problem...

Hi, Can any one tell me about this error in cube generation : (TR0148) Internal format error in the temporary file E:\temp\0X07C4\0E. [->OK]. We are using E:\Temp as the temperory folder and have updated configuration manager (UDF) and Transformer as well. The most frustrating part is that...

Hi We are working on SQL Server 2k and I want to monitor the server round the clock... major issue we wanna deal is the server space... the requirement is to monitor server performance, ie whenever there is some outage (like low memory, table truncation etc), I want to get an SMS on the...

Hi, We are working on a Data Warehouse. We have a situation when i have to summarize a group of rows in one row. presently we are doing this by using aggregate functions such as sum and max... My query is that is there a way to summarize in a more effective manner, ie without using the...

Hi, We are in the process of creating a Data Warehouse which will involve data in Tera Bytes. Client's requirement is to use SQL 2K as the RDBMS. Can any one tell me as to which is the Data Model we shall use (star/ Snow Flake etc) and why? Thanx in Adv. Vish

Hi, We are in the process of creating a Data Warehouse which will involve data in Tera Bytes. Client's requirement is to use SQL 2K as the RDBMS. Can any one tell me as to which is the Data Model we shall use (star/ Snow Flake etc) and why? Thanx in Adv. Vish

Hi, I need a business level documentation on Notice Cast. Can an one help me on that Vish

We are facing following problems in the Visualizer Web: 1. Visualizer Web server enables to publish the viz, but while connecting to the Zero Foot Print - Client Edition, we are getiing an error stating 'Processor Error (1)'. It started after republishing the viz at the same location. It...

Hi, Can any one tell me how to use Cognos Authenticator for protecting your cube on the web. Thanx