Jeremy Kashel's Blog - All Comments

Allocations in PowerPivot Using DAX

Jeremy Kashel's Blog — Sat, 27 Feb 2010 14:56:58 GMT

Although I didn't mention it, the inspiration for my last post was the excellent MDX Solutions 2nd

re: MDX - 12 Months to Date

Jeremy Kashel — Mon, 08 Feb 2010 15:44:57 GMT

Hi,

In this case I'm referring to a Time Utility Dimension. They can also be known as a Time Analysis Dimension or Date Tool.

It's generally always a flat dimension, so the structure to hold the members would only ever have a column to support one attribute/level. A lot of people even define the 4 needed members directly in a view, rather than holding them in a table.

Here are a couple of approaches to this:

sqlblog.com/.../datetool-dimension-an-alternative-time-intelligence-implementation.aspx

www.obs3.com/ssas_tips.shtml

Hope that helps...

re: MDX - 12 Months to Date

QuestionGuy — Fri, 29 Jan 2010 15:56:34 GMT

I'm a bit new to MDX, but apparently this leap year thing is a real problem for people to handle in MDX.

You say"

In the MDX Script, the first step is to scope on a member called [Time Analysis].[Time Analysis].&[2], which is the 12 Months to Date member in my Time Utility dimension:"

I don't quite understand what [Time Analysis] is....is this a dimension table that is already popuplated with some kind of data, based on Time Utility dimension. If so, what kind of data does Time Utility contain?(I'm look for field names I guess)

Thanks

Websites tagged "olap" on Postsaver

Websites tagged "olap" on Postsaver — Mon, 10 Aug 2009 09:29:18 GMT

Pingback from Websites tagged "olap" on Postsaver

XLCubed Version 5 Released

Jeremy Kashel's Blog — Fri, 13 Mar 2009 12:18:34 GMT

Interesting to see yesterday that XLCubed have released version 5 of their popular OLAP reporting tool

User links about "hierarchy" on iLinkShare

User links about "hierarchy" on iLinkShare — Fri, 20 Feb 2009 21:15:15 GMT

Pingback from User links about "hierarchy" on iLinkShare

Bookmarks about Excel

Bookmarks about Excel — Sat, 27 Dec 2008 07:43:53 GMT

Pingback from Bookmarks about Excel

PerformancePoint SP2 - Planning Fixes and a mini-feature

Sacha Tomey's blog — Tue, 09 Dec 2008 16:58:02 GMT

Jeremy has already announced the release of PerformancePoint Server SP2 and it's great to see that

re: Entering Dates in PPS Planning Assignments

Jeremy Kashel — Thu, 27 Nov 2008 16:34:16 GMT

Hi Thomas,

You're right - you can use CDate instead of DateAdd. It seems that my VBA isn't as sharp as it used to be! I'm not sure which is quicker, but its good that the MDX/VBA combination gives you options.

Many Thanks

Jeremy

re: Entering Dates in PPS Planning Assignments

thu — Thu, 27 Nov 2008 11:03:28 GMT

Hi Jeremy,

i think instead of using VBA!DateAdd("d", [Measures].[Value], "30/12/1899") you could just write VBA!CDate([Measures].[Value]) in MDX.

BTW, nice post!

Thomas

NativeMDXQuery Business Rules in PerformancePoint Planning

Jeremy Kashel's Blog — Fri, 24 Oct 2008 10:25:54 GMT

Having posted about NativeSql business rules a while back , I though that I might as well cover NativeMdxQuery

re: Using NativeSQL Business Rules for Seeding or What Ifs

Jeremy Kashel — Thu, 16 Oct 2008 09:42:07 GMT

Hi,

Yes I did mention returning the number of records affected, although in hindsight you will only ever see this if you are running your native rule in PBM.

If you do want to return the number of records affected, then you need a line in your in your native rule that is: IF object_id(N'tempdb..[#GeneratedCalc_Temp1]') IS NOT NULL INSERT INTO #GeneratedCalc_Temp1 VALUES (@retVal).

This temp table is then queried by BPM when the rule completes in order to display the number of rows affected. Note that the variable used (@retVal) should have @@rowcount appended to it after each statement. So if you have a delete statement first, then under this statement write set @retVal = @@rowcount. Then in the subsequent insert/update statement(s) write SET @retVal = @retVal + @@rowcount, so that @retVal always holds the total number of affected rows for the rule.

Hope that's what you're after

Best regards

Jeremy

Microsoft BI Conference - Day 1 - 6th October 2008

Sacha Tomey's blog — Fri, 10 Oct 2008 12:32:35 GMT

So, although later than the trail blazers , I thought I'd write up a brief note about day one of

Microsoft BI Conference - Day 1 - 6th October 2008

Sacha Tomey's blog — Fri, 10 Oct 2008 12:32:23 GMT

So, although later than the trail blazers , I thought I'd write up a brief note about the day one

Master Data Management « Charlie Maitland’s Blog

Master Data Management « Charlie Maitland’s Blog — Wed, 08 Oct 2008 21:25:06 GMT

Pingback from Master Data Management « Charlie Maitland’s Blog