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!
-
calculated measure -- aggregating sales data by set time constraints
Hello, you may add 2 properties to the levels of your time dimension : "start_date" and "PositioninMonth" and then use the FILTER MDX function to retrieve only the data you want : something like : {Filter( [Measures].[SALES_DATA]...- CodA75
- Post #2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
Return a string from a stored procedure?
before anwering I need to know from where you are executing your stored proc ? (DTS, another stored proc, others...) ? A+- CodA75
- Post #2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
-
crossjoin and dimension
Ok your query seems ok to me exept your two measures [zone] and [plant]; I explain : what you want is to retrieve some level properties ie name and parent name so why so you put them in tuple ? they are not data to be crossed ... Try this instead : member [Measures].[zone] as...- CodA75
- Post #2
- Forum: Microsoft SQL Server: Analysis Services (OLAP)
