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

Try this: 1. connect <ServerName> user <UserID> password <Pwd> disable <Folder_Path> 2. XCOPY <Source_Folder_Path> /S/E/y <Destination_Folder_Path> 3. connect <ServerName> user <UserID> password <Pwd> enable <Folder_Path> Regards, Vish

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

Thanx Brett... It helped Regards, Vish

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

Why dont you export the data in excel and do the analysis :) Vish

Hi, Take a distinct of your table and put it in a temperory table. Truncate the main table and and the load the data back from temp table Regards, Vish

Hi, Try exporting the data in excel and see if you are getting the correct results!!! Reply if you are getting correct result Vish

I created 2 tables as tmp1 and tmp2. tmp1 has data while tmp2 has one date field => for tmp1 select * from tmp1 gives 1234 2003-01-01 00:00:00.000 112 2003-01-03 00:00:00.000 9078 2003-01-04 00:00:00.000 => for tmp2 select * from tmp2 gives 2003-01-01 00:00:00.000...

HI, Just to add few more lines on what techie said, You may use a table with date field only and have an outer join with the one on the base table. 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, 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

In Continuation of my query, I need a basic understanding on how we can use Notice cast in a Cognos environment? Thanx in Advance Vish