I\'m trying to figure out how I can create a calculated measure that produces a count of only unique facts in my fact table. My fact table basically stores events from a historical perspective. But I
I have a requirement to show a report which calculates the average selling unit price of each product and then multiplies this average by the number of units forecasted to sell in the next year (for e
I\'m new to SSAS and I\'m not sure how to heavily customize a measure开发者_运维知识库. My fact table stores every change (events like created new page or deleted page).
We have a situation where, because OLAP is using a single DataSource view for all cubes, some of our aggregations are getting confused.
We have a set of SSAS 2005 databases that are maintained by various employees. The metadata/schema including format strings, etc. have evolved to represent a significan开发者_如何学Got amount of work
I have a fresh 64 bit SS 2008 R2 install on a new server running 64 bit Windows 7. (No previous versions of SS). BIDS is running on the same box as SS 2008 R2.
We currently run a front-end Manager Information tool that connects to a SQL analysis server to provide flexible reporting. Essentially the front-end builds up some MDX which it then executes on Analy
Hi I am no MDX Expert, so I need help, say I have a cube with the following data (simplified) Month EE CoCode Value
I need to send complex type object (marked RemoteClass in Flex) via NetConnection to other clients. [RemoteClass]
I\'m trying to create a role, to restrict acce开发者_Python百科ss to a cube on Analysis services, so that a member of this role can only see records related to a specific country (from a dim_country d
加载中,请稍侯......