Microsoft SQL Server Analysis Services
Tag Archive: Analysis Services
Today I would like to write few words about MDXMissingMemberMode. This is property of a dimension in SSAS and sometimes a need occur to change its default value. MDXMissingMemberMode has three possible values: Default Error Ignore where Default is Ignore….
In many scenarios developers must deal with many cubes in the same project and share dimensions between them. It’s easy to set up something like this but try to imagine situation when one cube musts be browsed by fiscal dates…
Today’s topic will be the unary operators in Analysis Services. They allow us to build custom rollup operations in hierarchies. In standard hierarchies, eg. Parent-Child child elements are aggregated to parent with one standard operator defined, in most cases it…
Today i discovered something that could be interesting for you if you work with multidimensional projects in MS technology. I’ve got calculations in my project some of them was named sets, I would like to test them during the final…