ssas

相关标签：javascript jquery android 多少钱 iPhone

Calculated Measure aggregating on certain cells only

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[详细]

2023-02-16 17:12 分类：问答
MDX Calculating 12 month average unit price and applying to forecast quantity

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[详细]

2023-02-16 15:38 分类：问答
SSAS - Creating a measure the only counts the newest events

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).[详细]

2023-02-16 08:04 分类：问答
In SSAS, can you ignore table relationships at the cube level?

We have a situation where, because OLAP is using a single DataSource view for all cubes, some of our aggregations are getting confused.[详细]

2023-02-15 22:03 分类：问答
SSAS programmatically back up metadata only

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[详细]

2023-02-14 18:04 分类：问答
SS 2008 R2 Analysis Services - Class not registered

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.[详细]

2023-02-14 05:16 分类：问答
Differing NON EMPTY behaviour in Analysis Server 2000 and 2008

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[详细]

2023-02-13 10:17 分类：问答
MDX Query use most recent value

Hi I am no MDX Expert, so I need help, say I have a cube with the following data (simplified) Month EE CoCode Value[详细]

2023-02-13 10:14 分类：问答
How to relay complex type via NetConnection to FMS?

I need to send complex type object (marked RemoteClass in Flex) via NetConnection to other clients. [RemoteClass][详细]

2023-02-12 11:35 分类：问答
SSAS Roles - Creating a Role to restrict access to the cube, by country

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[详细]

2023-02-11 23:03 分类：问答