The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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