[Show all top banners]

forcontact

More by forcontact
What people are reading
Subscribers
:: Subscribe
Back to: Computer/IT Refresh page to view new replies
 MS-SSAS MDX query
[VIEWED 2866 TIMES]
SAVE! for ease of future access.
Posted on 03-29-09 11:04 AM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

hi,
Can anybody tell me the mdx query to calculate the previous running 12 months and same period previous year (upto date level).
For same period previous year, I tried paralleperiod(([Time Dim].[Hierarchy Time].[Year],1,[Time Dim].[Hierarchy Time].currentmember), [Measures].[Sum of Sales])
It's not working properly. It gives me correct value for the year level and the date level but not for quarter or month level. My Hierarchy Time = Year, Quarter, Month, Date.
and for Previous running 12 months i don't know how to proceed. I want both as a calculated measure
If any body can guide me, I would be gratefull.
Thank you


 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 90 days
Recommended Popular Threads Controvertial Threads
TPS Re-registration case still pending ..
Toilet paper or water?
ढ्याउ गर्दा दसैँको खसी गनाउच
Sajha Poll: Who is your favorite Nepali actress?
Problems of Nepalese students in US
Mamta kafle bhatt is still missing
Tourist Visa - Seeking Suggestions and Guidance
To Sajha admin
From Trump “I will revoke TPS, and deport them back to their country.”
Are Nepalese cheapstakes?
अरुणिमाले दोस्रो पोई भेट्टाइछिन्
wanna be ruled by stupid or an Idiot ?
MAGA denaturalization proposal!!
Nepali Psycho
advanced parole
How to Retrieve a Copy of Domestic Violence Complaint???
seriously, when applying for tech jobs in TPS, what you guys say when they ask if you have green card?
and it begins - on Day 1 Trump will begin operations to deport millions of undocumented immigrants
I hope all the fake Nepali refugee get deported
Travel Document for TPS (approved)
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters