Can you post the MDX used?

Anybody working on this piece? I can take this up.

Yes you can the popular ways are:

1. Regression

2. Forecasting

What is the version of SQL Server you have?

Nish, if thats the case, why not use a Hybrid Query(Mix of MDX and SQL)

See this: http://www.sqlservergeeks.com/blogs/suhas/personal/545/sql-mdx-in-one-apartment-hybrid-query

Nish, you should create a new meaure For example:

WITH MEMBER [Measures].[Test Measure] as ([Measures].[Reseller Sales Amount],[Geography].[Country].&[United States],[Reseller].[Business Type].&[Warehouse])

The output remains same for INNER / LEFT / RIGHT and CROSS JOIN

DAX is a new query language. It is proposed as an alternate(not to replace) to MDX.

Nice and handy. Thank you.

You can also re-write as below:

WITH SET SetA as Except([PH_CUST].[Cust].Children,{[EMP].[PHWEB].[Activce].&[1]})

SELECT { } ON COLUMNS,

NON EMPTY { SetA } ON ROWS

FROM Ad_CUBE

You need to create caluclated measures for the COUNT measure and to filter by date you can use the colon(:) operator as in January 2012 : April 2012, which will...

Yes. Infact the data modeler has to walk the extra mile to ensure that the model is supplemented with all features planned. Also, since the the idea of self service...

This is a pretty common scenario. All you need to do is process these two tables and see the magic 🙂

I can do my bit.

Orlando, just 3 words...

Simple. Lucid. Clear.