dbTalk Databases Forums  

Question about non-aggregation within a dimension

comp.databases.olap comp.databases.olap


Discuss Question about non-aggregation within a dimension in the comp.databases.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Thomas Philipson
 
Posts: n/a

Default Question about non-aggregation within a dimension - 09-10-2003 , 06:49 AM






Hi,
I have a dimension that consists of intranet web pages and the measure
is the amount of hits each page has had. Below is a simple table
showing the structure.

Hits Hits
Pages Per Page Total
A 4 7
B 3 4
C 1 1

Now, the TOTAL-column is a simple COUNT but how do I go about showing
the number of page hits/page without the aggregation?

I suspect that I can override the standard aggregation with som kind
of MDX-functin but I could sure need som hints before I dig in :-)

Cheers
Thomas

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.