blogs.conchango.com

Why don’t you use the datepart function instead datepart(“q”,now()), Format function does not work for quarters.

You can use Ctsr(datepart("q",now())) to return a string like the format function

Noticed a syntax error. Correct syntax -> Cstr(datepart("q",now()))

Based on experience with Proclarity, the month/year name that you indicate is "May Year 2008" would come from the cube definition (SSAS) and not PerformancePoint itself. Not having worked with PerformancePoint, I could be wrong, but you might want to check with the cube designers if you want a change to that format.

Hi Jamie,

Mosha blogged about this a little while ago (see http://www.sqljunkies.com/WebLog/mosha/archive/2007/05/22/current_date_mdx.aspx).

After debating various options, Mosha concludes that: "[...] So the best solution, which is also the simplest one in terms of MDX, is to have a dedicated process, which will update MDX Script daily with the following line:

CREATE SET Today AS { [Date].[Calendar].[Date].[May 21, 2003] };

Where the name of today's date is hardcoded and changed every day. This will have the best performance, but it will also add a little management burden on the cube maintainer."

Obviously in your case the current quarter value would only need to be updated on a quaterly basis.

Hello Jamie! Why did not the time intelligence that you configure with the data source, work? This is a feature in PP M&A.

Sorry! Why can you not use ..

Mosha blog entry, pointed to by Nat is also good.

/Thomas

Performance Point Monitoring and Analytics!

Thomas

Jamie, here is a link:

http://office.microsoft.com/en-us/performancepoint/HA102411371033.aspx

OK! I have not used planning yet.

In planning we have the concept of $CurrentPeriod$ which is even more powerful than actual date... So that you can vary the $CurrentPeriod$ by model and by business process -- if you are capturing data entry for the last period even though you are past that time frame in the real world.

if you look at the mdx the addin generates for this when you make current period references you won't have to do string parsing.

Hi Jamie,

I agree that "May Year 2008" looks rediculous. However, you were given the chance to alter the format of the members in the time dimension when you created the application calendar in the "Define Period Naming Conventions" step.

Cheers,

Nick

If you were at a large oil company, for example, we'd ask you to write 187 different web services to return current quarter.  Ideally in C or C++.