Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dimension Levels
Here is a link about multiple hierarchies: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agenhancingdims_0d6b.asp An example is time: You want the user to be able to look at time by either calendar or fiscal, but not both at the same time. Setting up the dimensions... -
Dimension Levels
Thanks for your suggestion! So, if the original dimension is Dept Category SubCategory Product, Then wouldn't I have to put a member property of department on the department level of the dimension to make a virtual dimension? Is this alot of... -
Dimension Levels
I have a product dimension: Department Category SubCategory ProductName There are some applications that I'd like the user to be able browse all levels of the dimension, and other applications where I just want them to be able to go to the department level. Is there a... -
Dimensions on Axis Without Using CrossJoin
I tried your suggestion and get the same error: "Unable to open cellset -- Formula error - Unknown error" Looks like you have to always use crossjoins. The other option if the "flatten out" the dimension and put all the options in the fact table. Not the best solution... -
ForeColor, BackColor of Calculated Members
Anybody have any experience using the forecolor and backcolor properties of calculated members? I'm trying to display them on an asp page. Thanks! -
Dimension from table or property
When is it best to create a virtual dimension based on a member property, rather than right from the table? -
Virtual Cube Question
I have a report which includes store level information and order level information, and have to display everything together. Is it a good solution to produce two cubes at each level and make a vitual cube to see all info from both, or is it better to make a new fact table to roll up everything... -
Dimensions on Axis Without Using CrossJoin
Can you put different dimensions on one axis without using a cross join? I know you can do this: select {[deliverytype].[alldeliverytype], [deliverytype].[alldelivertype].children} on columns ... But, can you do this: select {[deliverytype].[alldeliverytype].children... -
Rolling Average
issahar, Again, thank you so much for you help! Could you please give me an example of using the lastperiods function? I tried it but can't seem to get it right. All the examples I have read use years, quarters, months, or weeks, but never a definitive day count. I think if I checked for... -
Rolling Average
issahar, Thank you so much for your response. I had not used that before. I will let you know how using the BottomCount function works. I tried this and it works as well: With Member [Measures].[90DayRollingAverage] as... -
Rolling Average
I am trying to write an mdx query that calculates the 91-day rolling average of order countm by store, by day of week. Initially, it was supposed to be a 90 day average, but since 91 is divisible by 7 for days of week, I changed it. The end result should be like: Store Monday Tuesday...
