Total, Sales

Gross profit (which is Total Sales - Total COGS).  [...]

Total Sales Revenue (Consolidation of Sales Pre-tax + Tax ).  [...] You will not require a rule for Total Sales Revenue.  [...] SalesProd1 // The rule is. ['SalesProd1 '] = 'SellingProduct1' * 'PrizeProdukt2'.  [...]

and I need to be able to analyse it in every way. For example. total sales to every shop network of all products, sales to one particular shop network in regions or even sales of one particular product to one particular shop.  [...] And you can slice and dice your Sales cube by Shop Network and/or City all you want to get what you need.  [...] Dim 3. List of Shop Networks, including a Total Shop Network member.  [...]

select cityid,sname, total_sale from sales.  [...] I created one simple cube called SAlES with 3 dimensions.  [...] CITYID, SNAME, SALE.  [...]

Will it be possible to make bigger cubes (example. salescube with 20'000 products and 10'000 customers), which is not an unrealistic spec.  [...] The total database files space is 180 M.  [...] i made some tests aun enlarged the 'product'-dimension of the sales-cube with additional 5'000 testproducts with vba (by creating 10'000, it's getting very slowly so that i stopped), and i could make a browserview (paste) on the salescube, enter data on this new products, the total are calculated very quickly.  [...]

Thanks Hugo for the rules primer. I have found that if I have two data elements. Sales and Test consolidated to Total.  [...] I assume the fact that both test and sales were equal to the same value is because the rules engine is naive and doesn't take the order the rules were created into consideration, this can only be consider a bug.  [...] It seems that there are 2 values held at intersection Sales and that the rule and hard entered values are both stored.  [...]

My Total would be the rowheader of the row with the total. (There is no unique name for that.).  [...] Another Example would be, show the Total of Europe without Austria.  [...] This should be possible for the picklist of page elements, too. A single value can also be the total of two or more.  [...]

it does work for the 3 underelements, but not for the total element.-(.  [...] Total ratio = total outbound / total inbound.  [...] Total inbound stock - total.  [...]

So what i want is that based on the UNIT_SALE the avg should be calculated for the selected consolidated elements within the selected dimensions.  [...] The facts dimension consits of UNIT_SALE as well as the total UNIT_SALE_AVG.  [...]

Internal Sales Asia =. 50 (100 and 200 are eliminated).  [...] Internal Sales China =. Japan 200.  [...] Internal Sales Europe =. 30 (40 is eliminated).  [...]