Recent content by nsoerensen

Thanks for the reply. Yes, I have another dimension where there is build a hierarchy. The problem about this, is that I'm already on 7 levels, which result in, that before I'm seeing the level I'm interested in, it is gone out to the right of the screen. So I'm looking for a way to put in...

Hi I'm building a cube with chart of accounts as a dimension. I can't get it to add op, on a member. ex. I have 4 sales members, and need to show a total sales. But on the same level in the dimension. I'm using Custom member formula, and have got it working if I only use one earlier member...

Hi.. I'm having a problem with Excel 2002, when I set up a Pivot-table based on a MS cube. When I started the update of data from the cube was very quick (I only have 1600 records), but many dimensions. All based only on my fact-table. At a time when I changed a dimension the update of data...

Hi As a fairly new user, I am running in to trouble about joins in Analysis Manager. I have a shared dimension build as a snowflake schema. Now, I don't get all of my records from my facttable. I have discovered that that columns in my facttable can be empty, so I got nothing for level 2 and 3...