Search results for query: *

Hello all, I need help with a correlated query. I am trying to join two tables on a key and get a record that is the latest from the other table. Let me try to explain this with an example. I have a cust_sales table with multiple records per customer. I also have promo table that have multiple...

Hello, We usually build the cube on windows ftp the .mdc file to solaris unix server. I would like to take advantage of the 'copy and activate' feature in 8.4 and wondering how do I add the unix location in Windows Transformer. I know this is possible since the user guide talks about it. Has...

Can someone help me understand how I can retrieve data from a xml data type? In this example below, I want to retrieve AddressNo & Area from the table. Sample code below. I am using Sql server 2005. I need a select statement returns the values from the column. Any help that you can provide is...

I need to join two tables where when the join condition is true, it should return YES and returns NO if it doesnt. Let me try to give an example: I have BOOK_RENTALS which contains customer names and books: JOHN SMITH, BOOKA JOHN SMITH, BOOKB JOHN SMITH, BOOKC and I have a BOOK_MASTER: BOOKA...

Hi all, I have two tables using simple inner join. For example, SELECT SUM(ACTUAL_AM) FROM SALES_SUMMARY SS, CALENDAR_TABLE CT WHERE SS.MONTH_KEY = CT.CALENDAR_KEY AND CT.YEARMONTH = 200612 I have an index on the sales_summary table on the month_key column. However, when i see the explain...

Hello all, Lots have been talked about the surrogate keys improving the join performance. Has anybody really tested it? Can someone point me to some benchmarking test results? Any help in this direction is much appreciated. Thanks & Regards,

We are trying to design a Covered Item dimension for an insurance company. If we want to capture three different dates in this dimension, effective date & expiration date of an item and the transaction date, how can this dimension be organized so that users can quickly figure how many items were...

Hello, I have a report which prompts to select from a list of Sales Rep names. Is there any way I can generate multiple reports for each of the the prompt values? Like if I have 200 sales reps, I want the reports to be run with 200 different values and saved into a folder. Is this possible in...

Hi, I have two tables, as follows: ItemTable:This table has one record per item for each month. Month_No,Item_no,Total_Sales 200401,0001A,22500.00 200402,0001A,36500.00 200403,0001A,23000.00 : : PriceTable:This table has one record per item, each month the price of the item changed. If price...

Is there anyway I can query the cube? I would like to be able to run a simple select statement or an MDX style statement against the cube. Is it possible? We dont have ReportNet or Cognos Query yet. TIAm

Hello all, We are working in a data migration project, and I am looking for a tool that can help me with data mapping. I am not talking about an ETL tool. We already have DataStage for that purpose. What I am looking for is any tool which can download the tables/fields etc and allow me to map...

Hello all, I have a table with two fields in it: Customer ID, Order No 12345, 556 12345, 678 12345, 123 00678, 12 00678, 145 97867, 456 I want to build a query which returns one record for each customer id and one column for each order no. The result set from the above table should look...

Hello all, I am trying to setup a jsp application on iis. I followed the instructions from the onjava.com and jakarta website etc, and successfully been able to run the examples jsp apps on the localhost. Next thing I want to do is to enable the jsp apps that is copied on to the virtual...

Hello all, I have an application where the users have made mistakes while typing a keyfield. For example, in the Customer transactions table, when they have to input a 10 digit customer id, they make a typo: Instead of entering 007892012, they enter 0072892021 or 007982012. Is there a way of...

Hello all, I am trying to summarize my data based on a column value. e.g: My data structure is as follows: RptMonth Sales 200201 500 200201 200 200202 100 200203 200 200203 500 200301 100 200302 100 200302 50 200306 200 I am trying to write an sql statement which...

Hello, When I build the cube using Incremental update on a monthly basis, it zeroes out the existing information. Lets say I have a cube with data populated from January 2002 through Janurary 2003, I incrementaly update for the month of Feb 2003, then it correctly populates for that month but...

Hello All, How to add a special category to another special category using a macro? Here is the code snippet I am using (just the relevant portion): Set objSpecCategory = objModel.Dimensions("Customer Groups").Categories.Add(trSpecialCategory) With objSpecCategory .Code =...