Report Portal

MDX: Slicer Override

In MDX, the WHERE-clause is commonly referred to as the "slicer". This is because the criteria placed in this clause is used to "slice the cube". Any query scoped named sets or members will be created/calculated within the context specified in the WHERE-clause. For example, the query below will return the Internet Sales Amount for each Calendar Year:

Read more...

Tags: excel, mdx, slicer

 

2007-2015 VidasSoft Systems Inc.