Search results for query: *

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

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.

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

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

When I process a cube, I get an error as follows: Error 2147221421 (Internal Error) Could not update query log Does anyone know what this means, and what I can do about it? Thanks.

I have a cube with several measures. I need to be able to calculate a period to date number across all measures for any selected time dimension member. Is it possible to do this without creating a separate PTD calculated measure for each measure?

I tried to design aggregations for my cube using MOLAP storage and 'Performance Gain Reaches 50%', but it tells me no aggregations have been designed when I click 'Start'. When I process the cube, it processes successfully. What could be causing this? Thanks.

I am trying to create alternate hierarchies in a dimension. However, the problem is that one of the alternate hierarchies has lowest level members that are parent levels in another hierarchy, see example below: Location.Gate AllLocations ATL-S ATL-GateA1 ATL-GateA2 BOS-S...

I am trying to create a hierarchical structure for measures, which Analysis Services doesn't allow. Is there any way to do this? Example: Cost1, Cost2 and Cost3 rollup to Cost which rolls up to Expenses. I know I can create calculated measures, but some of the children do not add up to the...

I have a 'Location' dimension. New locations (airport codes) are frequently added and I was wondering how I can update this dimension so that the new members are added to a catch-all bucket in the dimension table when the data is loaded. In Essbase you can update a dimension using the data...

I am trying to understand private and shared dimensions. If I have a single 'location' dimension table that is common between two star schemas in a database, can I use this table to create 2 private location dimensions for 2 cubes in a database or does the location dimension have to be a shared...

I am trying to test the writeback functionality of Analysis Services. I enabled a cube for writeback, created a role that has read/write access to all cells in the cube (Cell security, advanced, unrestricted), then used the Excel add-in to retrieve data at the lowest levels for every dimension...

One of my dimensions has multiple hierarchies, Job Code.Special Views and Job Code.Labor Groups. I am trying to create a calculated member in the LaborGroups hierarchy that equals the value of an upper level member in the SpecialViews hierarchy. I created a new calculated member and entered...