Search results for query: *

Hi there, There is currently some technology on the market that was developed expressly to address this problem. See: http://www.delostechnology.com Good luck

This prevents the quantities from totaling and brings the last day’s/week’s, etc number into the total. This needs to go in the cube’s time dimension under Advanced Properties, Custom Rollup Formula, on each level except the lowest one – e.g. Year [Time].currentmember.Lastchild Quarter...

I have have similar problems before and it turned out to be the access database "msmdrep.mdb" that had become corrupt. It may be a place to start. It is in \Program Files\Microsoft Analysis Services\Bin. This file holds the info about the cube. Good luck

I have found this forum very helpful, as well as http://sqlmag.com - do a search on OLAP - it has some good info. Also, the MS Analysis Manager Tutorial is a good way to get started. There are not many sites in MDX that are actually active at the moment but these should get you on your way...

I found the solution. I am using a financial calendar and i was trying to utilize the dimension name, instead of the actual table name (dim name is "Financial Calendar". I used the following: "dbo"."Calendar"."FinancialYear" = ('2000/2001') or...

I am having the same problem - did you ever resolve it and if so, how? Thanks for the help Kelee

I would like to include meta data e.g. source tables, exact calculation, etc on a cell level, so that if a user is unsure of a figure, he/she can view the meta data. I am using SQL Server 2000, with Excel and Data Analyzer on the front. Has anyone implemented Meta Data within OLAP services or...

Here are another 2 MDX statements that work: iif(Product.CurrentMember.Level.Ordinal > 0, ((Product.CurrentMember, [Store Sales]) / (Product.CurrentMember.Parent, [Store Sales])), ((Product.CurrentMember, [Store Sales]) / (Product.CurrentMember, [Store Sales]))) or...

This will give you averages over time: ([Time].currentmember,[Measures].[Units Shipped])/count (descendants([Time].currentmember, [Month])) or, this pretty much does the same thing: [Measures].[Units Ordered]/count(descendants([Time].currentmember, [Month])) Good luck

Create a Calculated Measure as follows: [Unit Sales]/SUM({[Product].Parent}, [Unit Sales]) then in advanced properties, set your format string to #.00% (It was the curley brackets that got me) You may find that you come out to 99% because of the rounding and you may get something strange at...

Not quite sure what you mean, but try: Length measure/sum(Members in filter for current dimension,Length measure)*100