TM1 Forum

Hi all,
After I'm input data value in many cubes and End user want reset value measure = zero.

How do ????

Thanks all

ChauBSD wrote:Hi all,
After I'm input data value in many cubes and End user want reset value measure = zero.

How do ????

Do by following the Request For Assistance Guidelines:

please don't ask very basic questions about how to do things in TurboIntegrator or Rules without at least looking through the relevant functions in the Reference Guide.

In this case the relevant functions include SubsetCreate, SubsetElementInsert, ViewCreate, ViewSubsetAssign, ViewZeroOut and a few others that are left as reading exercise for the viewer.

You may also want to search for Data Spreading though since this input spans multiple cubes that may be less useful for you.

ChauBSD wrote:Hi all,
After I'm input data value in many cubes and End user want reset value measure = zero.

How do ????

Thanks all

I have no idea what this question even means, or is supposed to mean. Alan' psycic powers must be strong today.

lotsaram wrote:

ChauBSD wrote:Hi all,
After I'm input data value in many cubes and End user want reset value measure = zero.

How do ????

Thanks all

I have no idea what this question even means, or is supposed to mean. Alan' psycic powers must be strong today.

The voice inside my head is telling me it has something to do with Zeroing out Cubes data

EvgenyT wrote:

lotsaram wrote:

ChauBSD wrote:Hi all,
After I'm input data value in many cubes and End user want reset value measure = zero.

How do ????

Thanks all

I have no idea what this question even means, or is supposed to mean. Alan' psycic powers must be strong today.

The voice inside my head is telling me it has something to do with Zeroing out Cubes data

Thank you very much, I asked this question because my clients have require: "when we test the data entry process is complete, we want to reset all the values ​​to 0" without any rule or code using TI.

Thanks you

ChauBSD wrote:

EvgenyT wrote: The voice inside my head is telling me it has something to do with Zeroing out Cubes data

Thank you very much, I asked this question because my clients have require: "when we test the data entry process is complete, we want to reset all the values ​​to 0" without any rule or code using TI.

One option is for them to put on a pair of ruby slippers and click the heels together three times while repeating "there's no zero value like home". Another is to write a nice note to Santa Claus and see whether he'll arrange it for them. A third is to find a lamp on a beach somewhere, polish it, and maybe the genie can grant it as one of the three wishes.

On a more practical basis though, and given that multiple cubes are involved and that there would seem to be some time between the input of the test data and the clearing of it (making the Undo option impractical and unreliable), a TI process would still seem to be the preferred option. If clicking an action button to clear the data is too much trauma for them, you may want to ask them exactly what it is that they do have in mind for clearing it. Or, if you're the trained administrator, you should have some other suggestions already. The question that you're asking isn't exactly on the cutting edge of TM1 technology. Out of curiosity, exactly how much training have you done?

However realistically, if this is test data as you seem to be suggesting it should be in a test environment (licence permitting) anyway and there shouldn't be any data that needs to be zeroed out of your production environment. If you absolutely must use the production cubes, you should at least have either a version or scenario dimension in them (different sites use different names for the dimension) which allows the test data to be written into a "Test" scenario, and the live data to be written into one of the real scenarios. In that way you can clear the data by simply blowing away the Test element from the dimension. You can reinstate it later if you need to do further tests.

Hi Alan Kirk

May be, I should have some other suggestions for my customer. Thansk you very much

If you want to clear data, without using a rule or TI, the easiest and fastest way is to use the Data Spreading functionality built into TM1. All you do is right-click on a cell and choose Data Spread, Clear. It will make the data disappear. If the node you select is a consolidation, it will clear every leaf-level node below it. I use this functionality all the time when testing systems. You can even zero out an entire cube with it if you want. It's extremely handy when you don't want to write a TI to clear just a part of a cube. Caveat: Make sure you turn off logging beforehand because the Clear will create a log entry for each cell cleared.

Note to others: Even though I don't like this guy's lack of forum etiquette, I answered in the hope that someone else would gain benefit.

ChauBSD wrote:May be, I should have some other suggestions for my customer.

This suggests that you are a consultant charging for your TM1 services. Do you mind me asking if that is the case?

You are avoiding answering Alan's direct questions about your training, which rubs me the wrong way, because at the same time you expect others to answer your questions. I would be obliged if you could confirm or deny if you are in fact a commercial service provider (disclaimer: you are not required to reveal that information).

Hi qml

I am self-taught and not through any training process.

Thanks your very much

ChauBSD wrote:I am self-taught and not through any training process.

I take it that you chose not to answer my question then?

tomok wrote:If you want to clear data, without using a rule or TI, the easiest and fastest way is to use the Data Spreading functionality built into TM1. All you do is right-click on a cell and choose Data Spread, Clear. It will make the data disappear. If the node you select is a consolidation, it will clear every leaf-level node below it. I use this functionality all the time when testing systems.

That's what I was alluding to when I said that the original poster could "search (the documentation) for Data Spreading". However I'm not sure it's a path that I'd recommend be used when "many cubes" are involved[1], which is why I didn't elaborate; it's too easy for one to be overlooked, especially if each user is expected to do their own clearing[2].

[1] It's not clear how many is "many", but the fact that test data is going to need to be cleared out because it's not isolated by instance or scenario suggests a less than optimal design. "Many" may therefore indeed be "maaaaannnnnyyyyyy".
[2] This is also not stated in the question (the poster has a history of being extraordinarily weak on following guideline 6 (what documentation did you look in?) but is none too flash about following guideline 3 (be specific) either), but if the users weren't doing it themselves and leaving it to a central Admin I'm not sure why they'd care to specify what methods should or shouldn't be used.