Search results for query: *

Hi, I have seen several examples of creating parent-child datagrids. Orders and Order Details is a good one. It is very easy to navigate from order to order and display (or even modify) the details in the child grid. But, what if instead of loading all orders and details when the dialog loads...

Hi, I understand that if you create a .mde file you are not able to see (or at least modify) objects inside the .mde file. That is exactly what I want to achieve, but when I create a .mde file out of my MS Access 2002 .mdb file, I still have access to all objects in the .mde file. I can even...

I am working with visual basic express. I am having trouble with a code that works fine in VB6, but is giving me the error "Attempted to read or write protected memory. This is often an indication that other memory has been corrupted" in vb express. I need to use the following function from a...

Hi, I have designed a Data Mart to track potato contracting and receiving. It is running well except for one scenario. Here is a brief introduction to my data mart and the problem. For each load I receive: 1- I add a row to the fact table with all the corresponding dimension surrogate keys...

Hi, I am designning a data mart and have a problem with one dimension table growing as fast as the fact table, that is slowing down the response times. I am using SQL 2000 and MS Analysis Services. We receive trucks loaded with oranges and they are graded to get some quality attributes. I...

Hi, I am designning a data mart and have a problem with one dimension table growing as fast as the fact table, that is slowing down the response times. I am using SQL 2000 and MS Analysis Services. We receive trucks loaded with oranges and they are graded to get some quality attributes. I...

Hi, I have a DTS package with one Transfer Objects Task to extract data from a transactional system into a data warehouse. The transactional system is in a different server than the DW one. They are linked servers. When I run the package I get the following error Error string...

Hi, I have customers, stores and products and a neat dimensional design as we can find in any book. But I want to be able to drill down using a hierarchy across dimensions like, - Stores - Customers - Products I want to select a store and then see all customers that bought some...

Hi, My OLTP systems logs every change so when transferring daily information from OLTP to my staging area I only transfer those records which suffered any changes. But I have a concern about staging area tables structure. Should tables in SA have a normalize or a denormalize structure? In the...

Hi, Im currently using Microsoft Analysis Services as my OLAP tool. I need to build a hierarchy from two separate dimensions. I mean those dimensions have a many to many relationship and I want to be able to drill down to see all records from dimension 2 belonging to a particular record from...

Hi, 1-Lets take the well known case study of customers, products, etc. Suppose I sell a product to a customer and store the sale in my fact table (which grain is the sale). But after 15 days the customer gives the product back. What would you advise to do in that case to represent that...

Hi, Lets take the well known case study of customers, products, etc. Suppose I sell a product to a customer and store the sale in my fact table (which grain is the sale). But after 15 days the customer gives the product back. What would you advise to do in that case to represent that event in...

Hi, Im trying to develop an outlook addin to work with different types of customize messages and need to use a rich text control or something similar for the user to "build" a message inside outlook interface (using rules and options I provide as part of my addin menu) Is there a...

Hi, I need to create a set of calculated members (around 30) in one of my OLAP cubes and would like to do it from a script or something similar to avoid the laborious task of creating them one by one (calculations are very similar) Maybe using DSO object model or MDX I can do it but I cannot...

Hi, Does anyone know how to represent null values in XML so when used in an OPENXML statement for updating a table (with an UPDATE statement) it inserts NULL instead of a blank on the cell ? Any help would be appreciated. // jcoira

Hi, I have a FACT table with measures like showed above TotalQuantity Percentage ParcialQuantity (calculated member) 100 1% 1 200 2% 4 100 3% 3 --------- --------...

Hi, I have a FACT table with measures like showed above TotalQuantity Percentage ParcialQuantity (calculated member) 100 1% 1 200 2% 4 100 3% 3 --------- --------...

Hi, I am working for a company in the goods distribution field and I need to design a DW from an existing OLTP system. Could anybody point me to an example related to my field to get some idea of what I can do ? When you read articles or books on DW, they only deal with products, stores and...

Does anyone know how can I change the background color of a part (selected) of a text in a RICHTX32.OCX control? I can change the fore color, but I can't find a way to change the back color (or highliht it). If not, do you know another rich text control I could use? Thanks, //jcoira

Hi, Suppose I have to design a datamart for a transportation company. I want to trace the quantity of passengers moving from place to place, using my buses. My fact table will have one row for each trip of my buses. Will look like: - Date_ID (from date dimension) - Origen city (from Region...