Viewing 15 posts - 1 through 15 (of 31 total)
If you are trying to directly access cube data, you should look at HTTP security. It is the only way in AS to do what you are trying to do.
You...
February 3, 2004 at 9:42 am
First of all, get MDX Solutions by George Spofford. Great reference when working with MDX.
Use the Filter function to return the filtered set. For example:
Filter([Products].members, [Product].currentmember.name = "Do Not Display")
HTH
Steve...
February 3, 2004 at 9:38 am
The simple answer in regards to AS is that either one works fine as the data is loaded into the cube structure.
The general rule I follow is if you need...
February 3, 2004 at 9:34 am
You cannot RUN this kind of query in Reporting Services. You will need to PREVIEW the report to see the data.
What I have done is, build the query with the...
February 3, 2004 at 9:30 am
Couple of comments to add --
Get the VB.NET designer and remove the VB.NET files after loading the RS builder. This has been tested and make the Visual Studio IDE a...
February 3, 2004 at 9:25 am
MDX Solutions by George Spofford is by far the best resource that I have found on MDX.
As far as your calculation goes, check out the Ancestor or Lag functions.
Steve Hughes,...
January 22, 2004 at 8:25 am
You should also check TempDB as it will be growing to support the indexes during the inserts.
Steve Hughes, Magenic Technologies
January 22, 2004 at 8:21 am
One serious limitation of Standard Server is that it does not support partitions. If you are currently using multiple partitions in your cubes you will not be able to move...
January 22, 2004 at 8:18 am
I have deployed a number of Analysis Services solutions and my recommendation to clients it to use Excel to begin with. This reduces training time and provides an opportunity for...
January 14, 2004 at 1:00 pm
Yes it should. However, for the future I would save them to .dts files and use some version control software to manage development.
Steve Hughes
Magenic Technologies
December 15, 2003 at 10:02 am
Do you know if you activated Very Large Dimension Management (VLDM)? This could be what needed the memory. VLDM dimensions actually lock space in memory to hold the...
December 15, 2003 at 9:57 am
My normal list of recommendations follow:
Analysis Services 2000 Step by Step, Microsoft Press
MDX Solutions, George Spofford, Wiley
msdn.microsoft.com -- AS Documentation, sqlserver.olap user group
Hope that helps.
Steve...
December 15, 2003 at 9:53 am
More than likely your calculation requires too much cube data to be sent to the client and you do not have enough memory to support it. I have worked...
December 15, 2003 at 9:50 am
If your daily balance is a calculated member based on a specific time member, you could test the value and if it equals 0 return the previous member which will...
December 15, 2003 at 9:45 am
Currentmember will impact every query no matter what level of time you are on. If you need this to always be at the year level use the following:
Ancestor(Time.Currentmember, Year)
Hope...
December 4, 2003 at 10:08 am
Viewing 15 posts - 1 through 15 (of 31 total)