On 6 July 2011 15:39, e-mail mgbg25171 <mgbg25...@blueyonder.co.uk> wrote:
> I've done it in the email body > eg total income = north.total + south.total where north and south are from dimension "region" and sales, cogs are from dimension "line item" ie all I need the queries to do is return "rectangles" data cells as a result of various means of specifying them such as 1 the method above or 2 north.income.sales:1990 --->returns 10000 3 north.total ----> returns 5000,4000 The dimensions will be dynamic so I want to be able to return the data to it's form before the extra dimensions eg in this case region was added i.e. Edit...nce you've created an extra dimension it doesn't look like you can dimension it seems to me that you can't just delete it cos everything would disappear. It seems the best you can do is just reduce it down to one value or as you say null but even then you need one entry. Hope this helps. BTW "income" is not a dimension value but just a convenience to automatically select sales and cogs. I haven't quite worked out how to represent this yet. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
