Пример 30. Вычисление процента

Функции форматирования

Пример 29. Функция проверки условия

Пример 28. Вычисление тренда

WITH

Member Measures.X AS

'Rank(Time, [Time]. [Month].Members)'

Member Measures.Trend AS 'LinRegPoint(X, [Time].[Month].Members,[Store Sales], x)'

SELECT

{[Store Sales], X, Trend} ON COLUMNS,

[Time].[Month].Members ON ROWS

FROM SALES

WITH MEMBER [Measures].[Diff] AS

' IIF (([Store Cost] > [Store Sales]),([Measures].[Store Cost]-[Measures].[Store Sales Net]),

([Measures].[Store Sales Net]-[Measures].[Store Cost]))'

SELECT

{[Measures].[Store Sales Net],[Measures].[Store Cost], [Measures].[Diff]} on columns,

{[Gender]. [Gender].members } on rows

from Sales

Вычислим процент с 2 знаками после запятой.

WITH member [Measures].[Store Profit Rate] as '([Measures].[Store Sales]-[Measures].[Store Cost])/ [Measures].[Store Cost]', format = '#.00%'

SELECT

{[Measures].[Store Cost],[Measures].[Store Sales], [Measures].[Store Profit Rate]} on columns, Order([Product]. [Product Department].members, [Measures].[Store Profit Rate], BDESC) on rows

FROM Sales

Дата добавления: 2014-12-10