Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
dynamic mdx calculated member
Hi, i am pretty new to mdx, i didn't need it until now, because i could use the built-in Aggregate Functions like max, min, avg,... . but now i need to calculate the median, which is not included in the buit-in functions. all i need is a mdx-statement for a calculated member, that returns the...- Zeus80
- Thread
- Replies: 0
- Forum: Data Warehousing/Big Data
-
DWH: Distinct aggregate
Hi, No i am not looking for weighted averages. I need the average value (and other measures) of all distinct objects in a certain time period (e.g. 1 month, 1 year,...), unaffected by the number of days an object was online in the time period.- Zeus80
- Post #3
- Forum: Data Warehousing/Big Data
-
DWH: Distinct aggregate
hey guys, i have the following problem and i can't solve it and can't find it in the literature either, because i don't know how to name it. .) imagine a website with different Objects(ObjectID, value) online. I designed Objects as Dimensiontable and my Facttable is just: (ObjectID, DateID)...- Zeus80
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
