Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Time Intellegence Parallelperiod calculations for missing months

Status
Not open for further replies.
naga5566

naga5566

Technical User
Mar 14, 2003
90
US
Hello,

I am new to SSAS and need help. I have a Date hirearcy as
Year->Quarter-Month and have calcualtions Current YTD,Previos YTD,
Current QTD,Previous QTD based on shell dimension, which work fine. However my requirement is, if i have no facts(nulls) for atleast one month in a quarter for Previous QTD, i need to show the Previous QTD as "None".

Thanks in Advance
Naga.

 
Status
Not open for further replies.

Similar threads

Benedito Almeida
  • Locked
  • Question
SSAS - Hide Some Calculated Members for a Time Dimension Level
Replies
0
Views
167
Benedito Almeida
Benedito Almeida
jbluedelta
  • Locked
  • Question
OLAP over HTTP and 503 error and connection time out
Replies
0
Views
197
jbluedelta
jbluedelta
Flybridge
  • Locked
  • Question
Calculated member and ParallelPeriod 1
Replies
8
Views
124
Flybridge
Flybridge
Rolaper
  • Locked
  • Question
MDX Calc measure to accomdate Smi-Additive and delta SCD at the same time?
Replies
0
Views
109
Rolaper
Rolaper
PerlIsGood
  • Locked
  • Question
MDX ParallelPeriod issue (SSAS Cube)
Replies
2
Views
80
PerlIsGood
PerlIsGood

Part and Inventory Search

Sponsor

Back
Top