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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Hurdles

    Calculated members [measure * dimension]

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

    Avg function compared to Essbase avg function

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

    Analysis Svr Member Properties

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

    Toolset Evaluation

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

    OLAP Cube Update

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

    Crystal 6 and MS OLAP

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

Part and Inventory Search

Back
Top