176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

MDX expert help needed...
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

May 21, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, May 18, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I need a generic ParallelPeriod function. Here is my scenario:

I've a role playing date dimension: Process Date and Effective Date. My user wants to have a handy calculation that should work as follows:

If the user brings in a particular attribute or hierarchy from the above mentioned date dimensions, the calculation should return the [Previous Period Sales Amt] on a measure called [Sales Amount]. [Previous Period Sales Amt] is defined as a previous day/month/quarter or the year.

The user should be able to slice the data with any other dimension's attribute/s or hierarchies along with one of these Date dimensions' attribute/hierarchy

If user doesn't bring any of the dates in the play and just brings any other dimenions (only), the [Previous Period Sales Amt] should be zero.

The way it can work is that either I can send you the backup of my cube or you can make a sample.

Sign in or Register to see more

Job ID: 30636666
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
Winner
Chad Dotzenrod has worked in the Microsoft technology stack for the last 14 years with heavy emphasis on business intelligence and database...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30651289  |  Submitted: May 20, 2012 00:28 ET 
Delivery
Within 3 days
$493.15
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »