Search results for query: *

You cant multiply dimension by measure. Dont think of 1 pack, 6 pack and 12 pack as numbers. They are just members of a dimension, like beer, cola, diet. At first glance maybe the easiest thing would be to put an IF stmt inside your calc member and hard code your multiplier...

I have an Avg formula in an Essbase member. I am trying to replicate this in MSAS. Essbase formula avg(expList) expList can be any member that returns a number, whether the list is of members from the same dimension or not myavg = avg(Jan:Mar,LA) Jan:Mar is the set Jan,Feb,Mar from my Time...

I have a member, it has a Member Property. How do I use an MDX stmt to get to that member property. I have Time dimension. Jan, Feb, Mar etc. I built a Member Property = "Alias", that is J, F, M etc. I looked in some books for the way to get hold of the property shows...

I work for a DW company, our main expertise is Essbase. It is a good tool, the most recent version is 6.0. It is really easy and you can make very complex dw cube. You build your outline (what they called the hierarchial structure of the cube). You can use a flat file to update it or you can...

I have built a cube using SQL Tables as the datasource. Is it possible to update the cube using a flat file (something other than updating SQL tables) I have it configured as a MOLAP, and do not want it to be ROLAP. As comparison, Hyperion Essbase is true MOLAP, you can build cube and update...

I created a VB App that uses ADOMD and MDX that generates a query from a cube in MS OLAP and puts it into a VB DataGrid. I want to hit a button to generate a report from the result set. 1. Can I generate a Crystal report directly from the DataGrid or 2. Can Crystal 6.0 access a MS OLAP...