I have two parameters: \'from month\' and \'to month\'. I would like to show data between those months. This is my situation:
Am using OLAP a开发者_运维百科nd i want to make measure functions e.g(count,max,..) to be selected by the user (to be as a filter).
I use MS SQL Server 2008 R2. I\'ve got the problem, please, excuse the long explanation. We\'ve got the SSAS cube. It is under development at this time, but it is partially working and can be access
I have a cube that shows order volume history, but showing the month to date numbers isn\'t that useful (since they\'re way out of whack with other full months). I want to include that data in some ki
I just started working with SSRS, and figured out how to connect my MDX Query to a Cube and plug that into a Matrix
In my Date Dimension I have 2 hierarchies: [Year - Week - Date] and [Year - Month - Date] I want to check in a Cube Calculation if the current level of the Date Dimension is [Date] (the lowest level
I\'ve run into some confusing behavior in Analysis Services 2005 (and 2008 R2) and would appreciate it if someone could explain why this is happening. For the sake of this question, I\'ve reproduced t
I created a report that returns, among other things, species of trees our company uses to make wood products. My query returns in this format: Species.Doug Fir. This is, of course, how the dat开发者_P
I\'m building an application with an underlying database that looks like a text-book example of OLAP: I have large amount of data that comes in every night, which then gets rolled up by time and other
Can I use CROSSJOIN in my WHERE statement? I need to take {[Product Attribute].[Attribute Code Number] and [Product Attribute].[Attribute] and compare them. There is a corresponding Code Number to a P