Indexing Dimix Dimnm Alias Attributes

Post Reply
smehnert
Posts: 3
Joined: Wed Oct 24, 2012 1:15 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 14

Indexing Dimix Dimnm Alias Attributes

Post by smehnert »

A general question about indexes...

Why would the index of model being restarted nightly require some of the dimensions to be reorded and saved in hierarchy order for the indexes to be correct.

The issue manifests itself when comparing the dimension element index its alias and then the index of the alias;

index dimnm dbra dimix
1 1 = part w attribute of w = washer dimix of washer = 1
2 2 = part b b = brake dimix of brake = 2
3 3 = part c c = cylinder dimix of cylinder = 5 ???

Any advice appreciated... :geek:
Christopher Kernahan
Community Contributor
Posts: 147
Joined: Mon Nov 29, 2010 6:30 pm
OLAP Product: Cognos TM1
Version: 10.1
Excel Version: Office 2010

Re: Indexing Dimix Dimnm Alias Attributes

Post by Christopher Kernahan »

A couple of questions;

- why are you restarting the service nightly?
- why are you relying on indexes?
- before the service restarts do you run a SaveDataAll?
smehnert
Posts: 3
Joined: Wed Oct 24, 2012 1:15 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 14

Re: Indexing Dimix Dimnm Alias Attributes

Post by smehnert »

Hi Chris -

The example I gave is for UAT version of a production model, this does not yet occur in the production model!

In answer to your questions;

- Restarting nightly to perform a data backup
- I am not relying on indexes, but I am on aliases and with them not reporting correctly it becomes a problem, the example I gave was a way to provide evidence of an issue
- The savedataall is probably not being performed... we have a seperate model we use to control all ther services with scheduled backups etc...

This only seems to occur when I take a copy of the live data folder into the UAT model and bring UAT up....

Simon
Post Reply