Creating new cube using existing dimensions but cannot see data

[wigglyrat]

Hi -

I have a requirement to replicate a new cube from an existing one. It will use the same dimensions as the existing cube however will also include a dimension called 'versions' in order to be able to hold different versions of budget data. I have copied across the rule files the new cube, and added relevant feeders. I understand that there is a bug in TM1 where you have to comment out rules to "trigger" them before they will load - this has been done. I have put together a view that duplicates an existing view in the old cube (except again for the new versions dimension) but there is no data. How do I get this to work?
Many thanks in advance,

[Wim Gielis]

Do you write rules and feeders to carry over the data from the old cube to the new cube ?
Or does that new cube expect actuals to be loaded ? Or other data ?

[wigglyrat]

The new cube has the same exact rules as the old cube. In the old cube data was pulled from other cubes, so it is just the same rules that pull the data from those cubes.

Initially I want the cube to just be like the old one with the new versions dimension. In versions there are actuals, then a forecast plan. I just want the original cube values to appear as actuals in the new version dimension.

Thank you for your help. I have only been working in TM1 for a few weeks so I fear it is something very obvious that I am missing.

[Wim Gielis]

Do you have feeders going from the cubes underlying the old cube, to the new cube ?
Or how is the feeding done ?

[mattgoff]

The new cube has the same exact rules as the old cube. In the old cube data was pulled from other cubes, so it is just the same rules that pull the data from those cubes.

Initially I want the cube to just be like the old one with the new versions dimension. In versions there are actuals, then a forecast plan. I just want the original cube values to appear as actuals in the new version dimension.

Thank you for your help. I have only been working in TM1 for a few weeks so I fear it is something very obvious that I am missing.

Please post your actual cube dimensions and rules/feeders for more efficient help. Speculating what you have or haven't done and/or playing 20 questions isn't productive.

I assume you were just using the expression but using "exact same rules" (and feeders, again, I presume) won't work since your dimensionality has changed. Technically the rules might work (putting the same calculated value in all versions) but feeders won't.

Matt

[wigglyrat]

Hi - the rules are present in the old cube. The rules here take measures from yet another cube via the DB function, and then the appropriate feeders are in that cube that the measures are being pulled from. So for the new cube I have just copied the rule file from the old cube in the hopes that they will just work in the same way they did in the old cube.
Thank you again for your help.

[mattgoff]

So for the new cube I have just copied the rule file from the old cube in the hopes that they will just work in the same way they did in the old cube.

That's not going to work (at least not in the way you think it will). Plus, you need to add feeders (hint: those are in rules for other cubes). If you want any more help, I suggest you post the info I requested earlier. If not...¯\_(ツ)_/¯

[wigglyrat]

Oh sorry, I missed your earlier post

The old cube has dimensions:

zz BDE
zz Class
zz Development Month
zz Underwriting Year
zz Accident Period
zz Policy Event Type
zz Measures

The new cube has all of these + one more:

zz Version

The rules in the old cube "BDE Test" were as follows/I'll just paste one for simplicity

Code: Select all

['zz Underwriting Year':'Unanalysed','Gross Earned Premium']=N:DB('zz Accident Year','Actual','All HOD',!zz Accident Period,!zz Class,attrs('zz BDE',!zz BDE,'Agency No'),!zz Policy Event Type,'All Cover Types',!zz Development Month,!zz Measures);

Then the corresponding feeder (in zz Accident Year) for this is:

Code: Select all

['Actual','All HOD','All Cover Types','Gross Earned Premium']=>DB('BDE Test',attrs('zz Broker',!zz Broker,'Agency No'),!zz Class,!zz Development Month,'Unanalysed',!zz Accident Period,!zz Policy Event Type,'Gross Earned Premium');

I thought the left side of the rule was where the data was going to - but there are no dimensions listed here so I thought (wrongly it seems!) that I could just use the same rule even though dimensionality has changed. But I am not sure where to go from here - how to incorporate this into the rule for the new cube?

Thanks again

[wigglyrat]

Just to add the measures - like Gross Earned Premium' for this cube are being pulled from a different cube entirely - zz Accident Year.

So I just want the new cube that includes the new dimension to also pull Gross Earned Premium from zz Accident Year as this did as well.

Thanks!

[wigglyrat]

Hi -

I have a requirement to add one additional dimension to a cube - I am using Perspectives so I understand to do this in this client you need to recreate the entire cube?

The old cube has the following dimensions:

zz BDE
zz Class
zz Development Month
zz Underwriting Year
zz Accident Period
zz Policy Event Type
zz Measures

In the new cube I need all of these plus one:

zz Version

It is not a very large cube, this old one, so I thought I would be able to just copy across the rule file from the old to the new. The rule takes several measures from yet another cube using a DB function.

Example rule:

Code: Select all

['zz Underwriting Year':'Unanalysed','Gross Earned Premium']=N:DB('zz Accident Year','Actual','All HOD',!zz Accident Period,!zz Class,attrs('zz BDE',!zz BDE,'Agency No'),!zz Policy Event Type,'All Cover Types',!zz Development Month,!zz Measures);

And then there is a feeder in the corresponding cube.

Example feeder:

Code: Select all

['Actual','All HOD','All Cover Types','Gross Earned Premium']=>DB('BDE Test',attrs('zz Broker',!zz Broker,'Agency No'),!zz Class,!zz Development Month,'Unanalysed',!zz Accident Period,!zz Policy Event Type,'Gross Earned Premium');

In researching this I see that use of TI is suggested to copy the data across, but for this as it is not a very large cube at present, is there a way to just modify rules and feeders to incorporate the one additional dimension?

Many thanks in advance,

[qml]

What was wrong with the previous thread that you decided to abandon it and ask the same question in a new one? It seemed difficult enough to force the necessary details out of you the first time round.

[wigglyrat]

I didn't get a reply to it. Will try again there.

[wigglyrat]

Apologies I have reposted this in another post as replies to this one have stopped. But in essence, as this is not a very large cube, I would like to - if there is a way just recreate it without having to write a TI to transfer the data across.

As there is only one additional dimension, is there a way to modify the existing rules (example provided above) to pull data back in from the cube as it had been working fine this way in the old cube.

Many thanks in advance

[qml]

You got whole 4 replies there. If you cared to phrase the question right the first time round then no more than 2 replies would have been necessary and you would have had your issue solved by now. I am frankly surprised that Wim and Matt had the patience to get that far with you.

[Edward Stuart]

This will not be the response you want but you would really benefit from reading the Rules Guide, if you are pushed for time then perhaps start at chapter 4

Don't give a fish, teach them how to fish and all that.

[mattgoff]

Apologies I have reposted this in another post as replies to this one have stopped.

Well, everyone here answering questions is volunteering their time, span across timezones, and have a lot of their own work and problems to solve. You can't rely on this forum for instant answers.

But in essence, as this is not a very large cube, I would like to - if there is a way just recreate it without having to write a TI to transfer the data across.

As there is only one additional dimension, is there a way to modify the existing rules (example provided above) to pull data back in from the cube as it had been working fine this way in the old cube.

Yes, there is. First, your rule. The left-hand side (LHS) is identifying the cells to which you want the calculation (RHS) to apply. If you don't provide an element in each dimension on the LHS, it will apply the rule to all elements in that dim. Since you probably don't want that calculation to apply to all elements in your new dimension, you need to pick one (probably) element in your new dim and add it to the LHS.

As an aside, your example rule has one dim on the LHS explicitly identified and one implicitly. I strongly advise you to use explicit notation everywhere as implicit notation can bite you (silently) later if future dimension edits make the implicit definition ambiguous (search the forum for several discussions on this topic).

Second, feeders. This assumes you're using SKIPCHECK (see how editing down things to "make it simpler" still leaves a lot of ambiguity, making the answer's job harder?) You need to identify where feeders for each rule originate. These may be in this rulefile or in others. You need to add your selected element in your new dim to each of these feeders.

I know this probably seems very complicated-- rules and feeders are a difficult topic for new TM1 admins as it's a concept not found is many (any?) other places. But, it's critical that you understand how they work if you're going to be administering TM1.

Matt

[wigglyrat]

Thank you so much - you have been incredibly helpful. I just did not update the feeder to take into account the new dimension.

Re reposting, as I had added another post to my query I thought it appeared as though someone had responded so that was why it went silent.

Thank you again!

[wigglyrat]

As a newbie I sometimes don't know what is relevant to post, but am getting better at this - apologies for this,

I found I had not been updating the feeder to account for the new dimension like I should have:

Code: Select all

['Actual','All HOD','All Cover Types','Gross Earned Premium']=>DB('zz BDE',attrs('zz Broker',!zz Broker,'Agency No'),!zz Class,!zz Development Month,'Unanalysed',!zz Accident Period,!zz Policy Event Type,!zz Version,'Gross Earned Premium');

All is working well now.

Thank you to all for the help.

[qml]

As a newbie I sometimes don't know what is relevant to post

That's why someone has made the effort to create the Request for assistance guidelines (PLEASE READ) thread, to make it easier for you to formulate a good question and for others to be able to help you without too much frustration.

[wigglyrat]

Thanks - I never came across this and it is immensely helpful.