CODEWITHSUNDEEP
sql-server-2012ssasbusiness-intelligence
masoud ramezani
masoud ramezani

Reputation: 22920

calculating new measures in SSAS

I have a cube in my sql server analysis service (2012) project. One of my measures is withdrawn money from ATM. Now I want to have a new calculated measure that show me the growth of withdrawn money today toward to last day. It is a dynamic calculated measure. Is there any solution for doing this work?

Upvotes: 1

Views: 312

Answers (3)

K4timini
K4timini

Reputation: 741

You should use KPI to build your measure.

Open your SSAS project in Visual Studio and double click on your cube. In the KPI tab there is a panel with some samples of KPI using parallel periods.

This is an example to create an operating margin accross two periods :

IIf
( 
  KPIValue( "Gross Profit Margin" ) >
  ( KPIValue( "Gross Profit Margin" ),
    ParallelPeriod
    ( 
       [<<Time Dimension Name>>].[<<Time Hierarchy Name>>].[<<Time Year Level Name>>],
       1,
       [<<Time Dimension Name>>].[<<Time Hierarchy Name>>].CurrentMember
    )
  ), 1, -1
)

Upvotes: 1

Diego
Diego

Reputation: 36136

if you want to show growth based on last value, for example today I Withdrew 10% less than yesterday, yo ucan use KIPs

if you want to show how much you Withdrew so far, you should use calculatins like YTD (year to date)

Upvotes: 1

Athanasios Kataras
Athanasios Kataras

Reputation: 26352

What you are looking for is most probably called a KPI = key performance indicator. Look here for information about how to add the metric you need.

Upvotes: 1

Related Questions