Search results for query: *

I was reading up on slowly changing dimensions too. Currently I use Essbase, and when the locations change from one parent to another, I am not required to keep track of the dates the change took place. I just restate the history to show up under the new parent. Wouldn't I get duplicate key...

The Location dimension table has two columns, location_parent and location. The child column is the primary key which is what is in the fact table as a foreign key. The Location hierarchy in Analysis Services looks like this (just an example): A A1 A2 B B1 B2 C C1 and the...

You're right, I would lose the history if I delete members with data in them. I am still confused about how I would automate updating a SQL server table from a flat file though. For example, my table looks like this to begin with (it's a parent child dimension): Parent Child A A1...

What if some dimension members are going to be deleted, and others moved around? Also, isn't 'Incremental Update' an Analysis services command rather than for updating a SQL server table? I'm thinking I first need to rebuild my SQL server table from the text file before I rebuild the...

From time to time the structure of some of the dimensions in my cube changes. The dimension tables are created from text files and I want to automate this process with DTS so that whenever the text file changes, the table is reloaded. The problem I have, is that if I truncate a dimension table...

I am trying to use a member property to do a calculation. The property is in the period dimension and is called UDA, and I am just testing to see if it works by creating the calculated member below, but I get #ERR when I look at the data. I am just trying to have it show a 0 if the member...

Add the 'Gross Profit' member to your dimension table in the required position. Add the formula in a Formula column. In the dimension editor enable the 'custom member' advanced option and select 'Use an existing column' and pick the formula column you created. BK

Thanks. That's what I was thinking of getting too. BK

One way to do this would be to add a column to your dimension table that specifies the bin that each member belongs to. Then use a parent-child dimension to create your dimension, with the parent being the bin column. BK

Does anyone know of a good MDX book to buy. I am really a beginner in MDX, but I am looking for something with lots of real life examples and tips.

Thanks for your help Justin. Although I didn't use the formula you mentioned, it did set me thinking in the right direction, and I got it to work the way I wanted. Thanks again! BK

Is there a way to average a measure across every member of the time dimension instead of summing it? I have a measure, Headcount, and my time dimension has Quarters, Months and Days. When I select Month, for example, I would like to see an average of the headcount for all days in the month...

Thanks. I do want to use the writeback feature to allow users to restructure hierarchies, but wasn't aware of a product that lets you do that, other than Analysis Manager.

I was reading that write enabled dimensions allow users to perform maintenance on parent child dimensions. I write enabled one of the dimensions but didn't know how the users would be able to use this feature through PTS or the addin. Is anyone familiar with this feature, and what front end...

I am trying to create a cube role that gives read access to everything and write access to the 'Plan' member of the Scenario dimension. I tried to follow the instructions in BOL but the writeback doesn't seem to work. I have write enabled the cube and created a writeback table. I created a...

I'm glad something finally worked for you! I know it was driving both of us crazy!

In one of your posts you mentioned that the Periodicity dimension has a 'Normal View' with an f symbol to show that it is calculated. Not sure what you meant by it, as 'Normal View' is not calculated but loaded from the fact table.

Your period dimension seems to have a lot more than just periods, like company and division, so I'm not sure what you are trying to do. You need to define the period dimension as a time dimension in order to use the period to date function. You can do this in 'Advanced' properties in the...

Can you describe your dimension table to me? Just do a select * from that table so I can see what you have. Also, can you list the steps you followed to create the calculated member?

Did you perform the following steps? 1. Create a dimension table for the Periodicity dimension with one member called 'Normal View'. 2. Add a column to the fact table with the value 'Normal View' in every row of data 3. Create the calculated member in the Periodicity dimension. If you did...