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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.