http://www.windowsitpro.com/authors/author/author/5777469/rsscomment/5777469en-USSun, 27 May 2012 07:27:06 GMTSun, 27 May 2012 07:27:06 GMThttp://www.windowsitpro.com/article/quering/mdx-by-example#commentsAnchorThu, 03 May 2012 04:31:18 GMT
For Query in No3 "past three quarters" will this Query below also work?.It looks more simple. with set [LastQuarter] as tail(Filter([Time].[Quarter].MEMBERS,[Time].CurrentMember),3) -- 'Tail(Filter([Time].[Quarter].Members, Not IsEmpty([Time].CurrentMember)),1)' select [LastQuarter] on COLUMNS, Non Empty Union(Descendants([Food], [Product].[Brand Name] ), Descendants( [Drink], [Product].[Brand Name] )) on ROWS from Sales]]>NishilThu, 03 May 2012 04:31:18 GMThttp://www.windowsitpro.com/article/quering/mdx-by-example#commentsAnchorhttp://www.windowsitpro.com/article/database-development/august-mdx-puzzle-solution-revealed#commentsAnchorTue, 03 Jun 2008 11:19:18 GMT
You will also need to wrap a filter around the products set to omit products with no sales.]]>ChrisTue, 03 Jun 2008 11:19:18 GMThttp://www.windowsitpro.com/article/database-development/august-mdx-puzzle-solution-revealed#commentsAnchorhttp://www.windowsitpro.com/article/database-development/august-mdx-puzzle-solution-revealed#commentsAnchorTue, 03 Jun 2008 09:05:06 GMT
Developer must always rip off their own code!!! I solved this for myself years ago, but now it’s come up again I don’t have my old code to refer back to. Good little article.]]>ChrisTue, 03 Jun 2008 09:05:06 GMThttp://www.windowsitpro.com/article/database-development/august-mdx-puzzle-solution-revealed#commentsAnchorhttp://www.windowsitpro.com/article/activex/mastering-olap-extending-mdx#commentsAnchorMon, 10 Dec 2007 10:01:59 GMT
OK, it downloads from the original article.]]>LauraMon, 10 Dec 2007 10:01:59 GMThttp://www.windowsitpro.com/article/activex/mastering-olap-extending-mdx#commentsAnchorhttp://www.windowsitpro.com/article/activex/mastering-olap-extending-mdx#commentsAnchorMon, 10 Dec 2007 10:01:59 GMT
OK, it downloads from the original article.]]>LauraMon, 10 Dec 2007 10:01:59 GMThttp://www.windowsitpro.com/article/activex/mastering-olap-extending-mdx#commentsAnchorhttp://www.windowsitpro.com/article/monitoring-and-analysis/analyzing-money#commentsAnchorWed, 13 Jun 2007 18:03:58 GMT
Need to find an article explaining ETL for text to currency format.]]>ClaudiaWed, 13 Jun 2007 18:03:58 GMThttp://www.windowsitpro.com/article/monitoring-and-analysis/analyzing-money#commentsAnchorhttp://www.windowsitpro.com/article/permissions/customizing-dimension-security#commentsAnchorWed, 30 Aug 2006 22:43:37 GMT
Can you update this for SSAS 2005? Since virtual cubes are no longer implemented, this probably falls under the many-to-many dimension.]]>JWed, 30 Aug 2006 22:43:37 GMThttp://www.windowsitpro.com/article/permissions/customizing-dimension-security#commentsAnchorhttp://www.windowsitpro.com/article/quering/june-mdx-puzzle#commentsAnchorThu, 24 Aug 2006 21:13:22 GMT
nothing]]>seethapathiThu, 24 Aug 2006 21:13:22 GMThttp://www.windowsitpro.com/article/quering/june-mdx-puzzle#commentsAnchorhttp://www.windowsitpro.com/article/quering/mdx-by-example#commentsAnchorWed, 28 Jun 2006 08:03:34 GMT
For example 12 "Which product brands’ sales have grown from one quarter to the next by more than 50 percent?" How should I eliminate brands that had no sales in the prev quarter? Thanks]]>ChrisWed, 28 Jun 2006 08:03:34 GMThttp://www.windowsitpro.com/article/quering/mdx-by-example#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2000/setting-display-characteristics#commentsAnchorFri, 21 Oct 2005 04:13:20 GMT
I found this cell properties doesn’t work in Excel. Does Excel (say version 2003) support cell properties?]]>WilliamFri, 21 Oct 2005 04:13:20 GMThttp://www.windowsitpro.com/article/sql-server-2000/setting-display-characteristics#commentsAnchorhttp://www.windowsitpro.com/article/quering/mdx-by-example#commentsAnchorMon, 18 Jul 2005 11:10:06 GMT
MDX is an intrinsic, great thanks for real and non-trivial samples.]]>Anonymous User Mon, 18 Jul 2005 11:10:06 GMThttp://www.windowsitpro.com/article/quering/mdx-by-example#commentsAnchorhttp://www.windowsitpro.com/article/database-development/time-dynamic-mdx#commentsAnchorTue, 14 Jun 2005 22:58:16 GMT
I appreciate the samples of count() function]]>Anonymous User Tue, 14 Jun 2005 22:58:16 GMThttp://www.windowsitpro.com/article/database-development/time-dynamic-mdx#commentsAnchorhttp://www.windowsitpro.com/article/database-development/time-dynamic-mdx#commentsAnchorTue, 14 Jun 2005 22:58:16 GMT
I appreciate the samples of count() function]]>Anonymous User Tue, 14 Jun 2005 22:58:16 GMThttp://www.windowsitpro.com/article/database-development/time-dynamic-mdx#commentsAnchorhttp://www.windowsitpro.com/article/activex/mastering-olap-local-cube-files#commentsAnchorWed, 25 May 2005 10:16:27 GMT
Actually, you can choose "Offline OLAP..." from Pivot table menu on PivotTable floating toolbar to save a cube file.]]>Anonymous User Wed, 25 May 2005 10:16:27 GMThttp://www.windowsitpro.com/article/activex/mastering-olap-local-cube-files#commentsAnchorhttp://www.windowsitpro.com/article/database-development/indispensable-calculated-members#commentsAnchorWed, 11 May 2005 09:51:00 GMT
hi If i have a string column in fact table which cannot be used as a measure to the cube as it displays numeric nor can i add as a member properties to any dimensions because of Datawarehouse consideration can you suggest some way of displaying that value as a string when you query using mdx as well as in the cube. thanks in advance regards Hemant emailid hemant_kanchan@hotmail.com]]>Anonymous User Wed, 11 May 2005 09:51:00 GMThttp://www.windowsitpro.com/article/database-development/indispensable-calculated-members#commentsAnchorhttp://www.windowsitpro.com/article/activex/mastering-olap-local-cube-files#commentsAnchorMon, 04 Apr 2005 14:09:33 GMT
Where does the excel sheet store the location of the cub file ? It seems that it always looks for the location where it was originally generated in]]>Anonymous User Mon, 04 Apr 2005 14:09:33 GMThttp://www.windowsitpro.com/article/activex/mastering-olap-local-cube-files#commentsAnchorhttp://www.windowsitpro.com/article/permissions/security-and-parameterization#commentsAnchorMon, 07 Mar 2005 14:02:47 GMT
This solution not is ease. I have a same problem, but this solution not resolve my trouble. I will like the references to study. Thanks]]>Anonymous User Mon, 07 Mar 2005 14:02:47 GMThttp://www.windowsitpro.com/article/permissions/security-and-parameterization#commentsAnchorhttp://www.windowsitpro.com/article/activex/mastering-olap-writing-applications-with-ado-md#commentsAnchorTue, 22 Feb 2005 02:30:01 GMT
this was an excilent artical to start with for mdx in vb]]>Anonymous User Tue, 22 Feb 2005 02:30:01 GMThttp://www.windowsitpro.com/article/activex/mastering-olap-writing-applications-with-ado-md#commentsAnchorhttp://www.windowsitpro.com/article/performance/optimize-analysis-services#commentsAnchorThu, 03 Feb 2005 10:02:02 GMT
good sumary]]>Anonymous User Thu, 03 Feb 2005 10:02:02 GMThttp://www.windowsitpro.com/article/performance/optimize-analysis-services#commentsAnchorhttp://www.windowsitpro.com/article/database-development/member-properties-revisited#commentsAnchorWed, 24 Nov 2004 08:23:22 GMT
Useless]]>webreviews Wed, 24 Nov 2004 08:23:22 GMThttp://www.windowsitpro.com/article/database-development/member-properties-revisited#commentsAnchorhttp://www.windowsitpro.com/article/data-access/member-properties-boot-camp#commentsAnchorWed, 24 Nov 2004 08:21:43 GMT
Useless]]>webreviews Wed, 24 Nov 2004 08:21:43 GMThttp://www.windowsitpro.com/article/data-access/member-properties-boot-camp#commentsAnchorhttp://www.windowsitpro.com/article/quering/custom-rollups#commentsAnchorSun, 24 Oct 2004 14:01:06 GMT
Excellent summary. Well explained..]]>GREGSun, 24 Oct 2004 14:01:06 GMThttp://www.windowsitpro.com/article/quering/custom-rollups#commentsAnchorhttp://www.windowsitpro.com/article/permissions/customizing-dimension-security#commentsAnchorWed, 20 Oct 2004 10:06:58 GMT
This works if the user is selecting something below the ALL level. What if you want to retain an "All" level containing ONLY the members the user has access to?]]>SCOTTWed, 20 Oct 2004 10:06:58 GMThttp://www.windowsitpro.com/article/permissions/customizing-dimension-security#commentsAnchorhttp://www.windowsitpro.com/article/quering/the-power-of-calculated-cells#commentsAnchorThu, 30 Sep 2004 13:32:43 GMT
Can I put an MDX Expression in place of the ’500’? For my SubCube, I want to show an increase in last year’s values by 10%.]]>Justin_S7 Thu, 30 Sep 2004 13:32:43 GMThttp://www.windowsitpro.com/article/quering/the-power-of-calculated-cells#commentsAnchorhttp://www.windowsitpro.com/article/database-development/time-dynamic-mdx#commentsAnchorTue, 21 Sep 2004 07:28:33 GMT
To diffiecult: This is easier. Tail(Filter([Time].[Month].Members, NOT IsEmpty ([Measures].[Sales Net]))) The above doesn’t work on rolling averages. ]]>webreviews Tue, 21 Sep 2004 07:28:33 GMThttp://www.windowsitpro.com/article/database-development/time-dynamic-mdx#commentsAnchorhttp://www.windowsitpro.com/article/sql-server-2000/setting-display-characteristics#commentsAnchorMon, 02 Aug 2004 08:15:53 GMT
The query in the 1st page of the article should have ({[Product].[Product Family].&[Food]}) instead of ({[Product],[Product Family],&[Food]}). As the one given below WITH CELL CALCULATION Sample FOR ’({[Product].[Product Family].&[Food]})’ AS ’CalculationPassValue(Product.CurrentMember, 0 )’, CONDITION = ’CalculationPassValue((Product.CurrentMember,[Unit Sales]), 0 ) > 12000’, FORE_COLOR = ’255 * 256’ SELECT [Product].[Product Family].Members on Columns FROM Sales ]]>Vinay DharmikMon, 02 Aug 2004 08:15:53 GMThttp://www.windowsitpro.com/article/sql-server-2000/setting-display-characteristics#commentsAnchorhttp://www.windowsitpro.com/article/monitoring-and-analysis/september-2003-mdx-puzzle-solution#commentsAnchorTue, 20 Jul 2004 11:54:45 GMT
Need more info]]>webreviews Tue, 20 Jul 2004 11:54:45 GMThttp://www.windowsitpro.com/article/monitoring-and-analysis/september-2003-mdx-puzzle-solution#commentsAnchorhttp://www.windowsitpro.com/article/quering/the-power-of-calculated-cells#commentsAnchorSat, 26 Jun 2004 02:58:02 GMT
how to include a named set in a calculated cell in a virtual cube]]>sunilSat, 26 Jun 2004 02:58:02 GMThttp://www.windowsitpro.com/article/quering/the-power-of-calculated-cells#commentsAnchorhttp://www.windowsitpro.com/article/permissions/customizing-dimension-security#commentsAnchorWed, 23 Jun 2004 21:11:12 GMT
How about memory usage with this approach? Will analysis server create a replica dimensions for each user? Just like role recurity? Thanks.]]>JOELWed, 23 Jun 2004 21:11:12 GMThttp://www.windowsitpro.com/article/permissions/customizing-dimension-security#commentsAnchorhttp://www.windowsitpro.com/article/activex/mastering-olap-extending-mdx#commentsAnchorTue, 22 Jun 2004 19:15:54 GMT
In your example, there is no performance benefit, is that right? The client side still get all the data but filter out those that don’t make the criteria.]]>Mark Han Tue, 22 Jun 2004 19:15:54 GMThttp://www.windowsitpro.com/article/activex/mastering-olap-extending-mdx#commentsAnchorhttp://www.windowsitpro.com/article/activex-data-objects-multidimensional-ado-md/local-cube-mdx#commentsAnchorTue, 15 Jun 2004 09:44:31 GMT
Your Comments (required):Very easy, clear, usefull; what I was looking for!]]>Roberto Calanca Tue, 15 Jun 2004 09:44:31 GMThttp://www.windowsitpro.com/article/activex-data-objects-multidimensional-ado-md/local-cube-mdx#commentsAnchorhttp://www.windowsitpro.com/article/database-development/mastering-olap-why-bother-#commentsAnchorFri, 14 May 2004 06:53:05 GMT
Information provided about OLAP is precise, gives good understanding of why OLAP and what more OLAP can do when compared to OLTP]]>vijayaFri, 14 May 2004 06:53:05 GMThttp://www.windowsitpro.com/article/database-development/mastering-olap-why-bother-#commentsAnchorhttp://www.windowsitpro.com/article/ole-db/analysis-services-interfaces#commentsAnchorTue, 27 Apr 2004 09:02:59 GMT
I was expecting to see more detail. For example, pros and cons of each, code samples...However, I’m at best a want to be analysis service developer and its good not to be nipped in the bud.]]>stephen clark Tue, 27 Apr 2004 09:02:59 GMThttp://www.windowsitpro.com/article/ole-db/analysis-services-interfaces#commentsAnchorhttp://www.windowsitpro.com/article/quering/custom-rollups#commentsAnchorFri, 23 Apr 2004 07:48:39 GMT
Quite good summarizing article of one of the main technics used in OLAP]]>Gediminas Fri, 23 Apr 2004 07:48:39 GMThttp://www.windowsitpro.com/article/quering/custom-rollups#commentsAnchorhttp://www.windowsitpro.com/article/quering/mastering-olap-cell-level-security#commentsAnchorTue, 20 Apr 2004 22:27:32 GMT
good article ........... hi i want to know how the same thing((applying roles to different db’s cibes)) is implemented for multiple databases using vb /c#.net]]>prasadTue, 20 Apr 2004 22:27:32 GMThttp://www.windowsitpro.com/article/quering/mastering-olap-cell-level-security#commentsAnchorhttp://www.windowsitpro.com/article/quering/custom-rollups#commentsAnchorTue, 13 Apr 2004 07:23:33 GMT
They always write a lot and say nothing that will help solve anything.]]>Jim Doe Tue, 13 Apr 2004 07:23:33 GMThttp://www.windowsitpro.com/article/quering/custom-rollups#commentsAnchorhttp://www.windowsitpro.com/article/activex-data-objects-multidimensional-ado-md/a-deeper-look-at-drillthrough#commentsAnchorWed, 04 Feb 2004 13:33:56 GMT
The download for InstantDoc #40382 didn’t work. There was a VBA compile error in Excel when opening.]]>TC Wed, 04 Feb 2004 13:33:56 GMThttp://www.windowsitpro.com/article/activex-data-objects-multidimensional-ado-md/a-deeper-look-at-drillthrough#commentsAnchorhttp://www.windowsitpro.com/article/activex-data-objects-multidimensional-ado-md/a-deeper-look-at-drillthrough#commentsAnchorFri, 30 Jan 2004 15:39:51 GMT
very disappointed this article circumvented how to utilize drillthrough with multiple dimensions on page axis with multiple selections enabled.]]>P. Del Fri, 30 Jan 2004 15:39:51 GMThttp://www.windowsitpro.com/article/activex-data-objects-multidimensional-ado-md/a-deeper-look-at-drillthrough#commentsAnchorhttp://www.windowsitpro.com/article/activex-data-objects-multidimensional-ado-md/a-deeper-look-at-drillthrough#commentsAnchorWed, 26 Nov 2003 07:20:56 GMT
This code actually has a bug. When one filter(or page field) for the Pivot table has varios items selected the page field has the caption "Various items", in the inner loop where the page fields are checked, the property CurrentPageName for the object PageFields is empty and causes the code to fail.]]>Camilo Gutierrez Wed, 26 Nov 2003 07:20:56 GMThttp://www.windowsitpro.com/article/activex-data-objects-multidimensional-ado-md/a-deeper-look-at-drillthrough#commentsAnchorhttp://www.windowsitpro.com/article/quering/dimension-writeback#commentsAnchorFri, 24 Oct 2003 01:13:24 GMT
Yeah but no one is writing about changing the name (key) displayed in dimension. The samples are as usual a sort of eternal "hello world" case - that can be found in MS SQL documentation too. Making an article by following the MS documentation is useless.]]>Horatiu Ripa Fri, 24 Oct 2003 01:13:24 GMThttp://www.windowsitpro.com/article/quering/dimension-writeback#commentsAnchorhttp://www.windowsitpro.com/article/quering/august-2003-mdx-puzzle-solution#commentsAnchorFri, 03 Oct 2003 13:13:03 GMT
In reviewing this solution, the code to filter only those customers that are not single or female doesn’t make sense. When I change the filter condition to "> 0" from ’= 0" and drop the Topcount, I see only customers that are single and female. (Kinda what I would expect). Then change it back to "> 0" and I see the other possible combinations (Married and Female or Single and Male, etc) and single and female if the unit sales is null. Doesn’t make sense. Can someone give me a better explanation for this behavior. Thanks, Jeff]]>Jeff Jones Fri, 03 Oct 2003 13:13:03 GMThttp://www.windowsitpro.com/article/quering/august-2003-mdx-puzzle-solution#commentsAnchorhttp://www.windowsitpro.com/article/data-access/member-properties-boot-camp#commentsAnchorMon, 28 Jul 2003 01:01:10 GMT
The showing of member properties through a cube view of information is possible by using O2OLAP for Excel. www.o2olap.com]]>Howard Taylor Mon, 28 Jul 2003 01:01:10 GMThttp://www.windowsitpro.com/article/data-access/member-properties-boot-camp#commentsAnchorhttp://www.windowsitpro.com/article/quering/december-2002-mdx-puzzle-solution#commentsAnchorWed, 12 Feb 2003 13:47:21 GMT
The solution given will result in incorrect averages if the 3 periods include a period with no data for a given data point. In order to avoid this problem: WITH MEMBER [Measures].[Rolling Sales] AS ’AVG(LASTPERIODS(3), CoalesceEmpty([Store Sales],0))’ SELECT DESCENDANTS( [Time].[1997], [Time].[Month]) ON COLUMNS, { [Rolling Sales], [Store Sales] } ON ROWS FROM Sales]]>Maureen Costello Wed, 12 Feb 2003 13:47:21 GMThttp://www.windowsitpro.com/article/quering/december-2002-mdx-puzzle-solution#commentsAnchorhttp://www.windowsitpro.com/article/activex/using-ado-md-with-net#commentsAnchorFri, 27 Sep 2002 08:19:24 GMT
The author isn’t a very good programmer. Has he heard of System.Reflection.Missing.Value? That’s how you pass MISSING PARAMETERS to COM INTEROP. No need to use InvokeMember. Also, it’s null not NULL! And String.Empty, not "". This code won’t even compile.]]>jonathanFri, 27 Sep 2002 08:19:24 GMThttp://www.windowsitpro.com/article/activex/using-ado-md-with-net#commentsAnchorhttp://www.windowsitpro.com/article/quering/diving-into-mdx-queries#commentsAnchorThu, 26 Sep 2002 08:14:48 GMT
This is more a question than a comment, but since i don’t know where to send this, i would appreciate that if you are not able to answer this question, to forward it to the right place. Ok, I juste want to have a date month number (exemple : 2001-05-15 give 5) and then i want to calculate the percent of year past at this date (5 / 12 in percent)]]>David Doucet Thu, 26 Sep 2002 08:14:48 GMThttp://www.windowsitpro.com/article/quering/diving-into-mdx-queries#commentsAnchorhttp://www.windowsitpro.com/article/activex/mastering-olap-local-cube-files#commentsAnchorSun, 14 Apr 2002 23:39:09 GMT
how can we save as .cub file.But it is easy to create cube file but not able to save it]]>ramSun, 14 Apr 2002 23:39:09 GMThttp://www.windowsitpro.com/article/activex/mastering-olap-local-cube-files#commentsAnchorhttp://www.windowsitpro.com/article/database-development/member-properties-revisited#commentsAnchorMon, 28 Jan 2002 12:27:15 GMT
The printer friendly version isn’t. The words get cut off. The ironic part is that the top level (video-friendly?) version prints just fine. I’m using Win2000, IE6.0 and HP LaserJet 5000.]]>Scott Stonehouse Mon, 28 Jan 2002 12:27:15 GMThttp://www.windowsitpro.com/article/database-development/member-properties-revisited#commentsAnchorhttp://www.windowsitpro.com/article/quering/distinct-count-queries#commentsAnchorFri, 30 Nov 2001 09:26:33 GMT
Your example covers much of the same ground as Amir’s. I am very much interested in something you said about using SQL 2000’s distinct count aggregation type. Is there any way to use this new aggregation in an MDX query to speed up a basket analysis query - like your pizza example?]]>Johnson Au-Yeung Fri, 30 Nov 2001 09:26:33 GMThttp://www.windowsitpro.com/article/quering/distinct-count-queries#commentsAnchorhttp://www.windowsitpro.com/article/quering/december-2001-mdx-puzzle#commentsAnchorMon, 26 Nov 2001 12:42:51 GMT
Sorry if this is the wrong place for this. I was wondering where to find the database for the MDX puzzles. Is this something that has been an ongoing creation?]]>Richard Copeland Mon, 26 Nov 2001 12:42:51 GMThttp://www.windowsitpro.com/article/quering/december-2001-mdx-puzzle#commentsAnchorhttp://www.windowsitpro.com/article/monitoring-and-analysis/analyze-disk-utilization#commentsAnchorWed, 08 Aug 2001 02:46:14 GMT
An interesting article, but not everybody stores their data on the c: drive! The Diskdata.exe program would have been much more useful had it includeded the ability to chose the drive you wanted to analyze. While not adverse to doing some work to take advantage of interesting techniques, I was disappointed not to be able to get any immediate benefit from the article.]]>NCharles Wed, 08 Aug 2001 02:46:14 GMThttp://www.windowsitpro.com/article/monitoring-and-analysis/analyze-disk-utilization#commentsAnchorhttp://www.windowsitpro.com/article/quering/may-mdx-puzzle#commentsAnchorMon, 02 Jul 2001 11:56:36 GMT
The solution to the problem is with member [Measures].[CustomerCount] As ’DistinctCount(CrossJoin({Customers.[Name].Members},{[Promotions].CurrentMember}))’ set [ResultSet] As ’[Promotions].[Promotion Name].Members’ member [Measures].[Result] As ’MAX([ResultSet],[Measures].[CustomerCount])’ select {[Measures].[Result]} on columns, {Filter([Promotions].[Promotion Name].Members,[Measures].[CustomerCount]=[Measures].[Result])} on rows from sales]]>Vishwanathan Raman Mon, 02 Jul 2001 11:56:36 GMThttp://www.windowsitpro.com/article/quering/may-mdx-puzzle#commentsAnchorhttp://www.windowsitpro.com/article/activex/mastering-olap-local-cube-files#commentsAnchorMon, 19 Mar 2001 14:35:26 GMT
Although it is easy and nice to create a local cube file, I found it would lose member key sorting property and reverse to member name sorting. Why?]]>DavidMon, 19 Mar 2001 14:35:26 GMThttp://www.windowsitpro.com/article/activex/mastering-olap-local-cube-files#commentsAnchorhttp://www.windowsitpro.com/article/data-management/ready-get-sets-go-#commentsAnchorWed, 31 Jan 2001 10:02:27 GMT
Have basic knowledge of OLAP or Analysis Services? Target audience: developer or DBA. This article brings useful information on "Sets" to your attention!]]>Michael B. Johnson Wed, 31 Jan 2001 10:02:27 GMThttp://www.windowsitpro.com/article/data-management/ready-get-sets-go-#commentsAnchorhttp://www.windowsitpro.com/article/database-development/indispensable-calculated-members#commentsAnchorTue, 21 Nov 2000 17:49:01 GMT
Hey this stuff is awesome. I was about to go buy _OLAP_Unleased_ (which I still plan on doing) to get this rush demo done, but all I needed was to look here. And to think . . I was trying to use a sub-query to get Ytd() working. =)]]>Yoway Buorn Tue, 21 Nov 2000 17:49:01 GMThttp://www.windowsitpro.com/article/database-development/indispensable-calculated-members#commentsAnchorhttp://www.windowsitpro.com/article/database-development/analysis-services-actions#commentsAnchorSun, 02 Jul 2000 14:10:44 GMT
Is there an event model that fires these "Analysis Services Actions"? From what I gather from the article, you can fire the action from the cube browser accompanying the server by right-clicking (onContextMenu?) at the leaf level, or at the client through custom programming. Is this the beginning of Triggers, such as there are in SQL Server’s relational database? The example of displaying additional information through html is definitely a good example, but I would suggest that we may be putting business logic in the wrong location of an n-tier system. Unless there is an event model associated with SERVER actions, I see this as functionally equivalent to running the same action you would normally have as the recipient of an event, only that parameters passed to that event are the results of an MDX statement.]]>Ken O. Bonn Sun, 02 Jul 2000 14:10:44 GMThttp://www.windowsitpro.com/article/database-development/analysis-services-actions#commentsAnchor