Search results for query: *

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...

Anybody have any experience using the forecolor and backcolor properties of calculated members? I'm trying to display them on an asp page. Thanks!

When is it best to create a virtual dimension based on a member property, rather than right from the table?

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...

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...