Geeks With Blogs
James Rogers BI from the trenches... November 2009 Entries
PerformancePoint Filter Query suggestions
As I have moved forward with PerformancePoint I have made extensive use of queries for filter building. This approach has a couple of distinct advantages over the other options. Allows filters to be dynamic and pick up new data as it becomes available. One good example of this is a date filter. We use it to keep our filters as a dynamic set of n time periods from the current time period back (i.e. lastperiods(52,exists([Date... Date].&[1]).item(0))) It allows ......

Posted On Wednesday, November 4, 2009 1:14 PM

SQL Azure shows promise for small data applications - not there for BI yet.
I am currently sitting in a seminar on BI in the Cloud by John Welch at the PASS Summit 2009. SQL Server Azure looks promising for a variety of applications. Currently it only supports SQL Server relational database services but future plans to include the BI stack of SQL Server. I have yet to see how loading of data is handled and security is handled but it seems to have a lot of potential for small data sets (< 10 GB). Couple of points: Apparently data manipulation is slower than normal SQL ......

Posted On Wednesday, November 4, 2009 12:49 PM

Copyright © James Rogers | Powered by: