Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Do you really want to delete this prezi?
Neither you, nor the coeditors you shared it with will be able to recover it again.
Make your likes visible on Facebook?
Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.
Transcript of Bedrock TM1
initially 10,000 lines of Best Practice, “Blackbelt”-aware, Project battle-tested Turbo Integrator Code. 'Data Shuffling'
Tool of TM1 Turbo Integrator BedrockTM1.org What's new in Bedrock 2.0 Upgrading from 1.0?
You can start using 2.0 today. View Creation
Bedrock.Server.LogFile.Load.TM195.pro Bedrock 2.0 – New Processes Bedrock.Server.LogFile.Backout.TM195
Only works with 9.5 and above
Uses the “Old Value” in the TM1 log file to remove updates from a TM1 cube performed by a specific client with in a date-time range
Only works with 9.5 and above
Updates a TM1 cube using the “New values” from the TM1 log file for a specific client with in a date-time range Bedrock 2.0 – Log File Bedrock.Server.DataDir.Backup.pro
Copies the contents of the data directory to another directory
Runs a Save Data All first
Creates a text file with a list of the contents of the data directory
Useful for documentation Bedrock 2.0 – Data Directory Bedrock.Dim.CloneFromSubset
Clones a dimension based of a subset
Builds a flat dimension with all N level elements from a subset
Use when you need a flat dimension for data entry of variables for C level calcs Bedrock 2.0 – Dimension Cloning Bedrock.Cube.ViewAndSubsets.Delete
Sister process to Bedrock.Cube.View.Create
Use to remove the view and subsets that have the same name as the view Bedrock 2.0 – View Deletion Bedrock.Cube.View.Create
A new process to create a view based off the filter concept introduced as part of the ZeroOut process in Bedrock 1.0
Basis for the new Data.Clear process and Data.ExportToFile
3 delimiters instead of 2, default is colon, ampersand & plus signs.
Example: Year: 2010 & Version: Actual + Budget
Can be used any time you want to create a view in code
If a consolidated element is part of the filter and consols are suppressed it will return N level elements
Options for new features: wildcards searches, attribute lookup? Bedrock 2.0 – View Creation Why?
Prime reason is to remove objects created during TI processes
Keep a clean system
Views and subsets weren’t be reused because of the random number
Most systems don’t require the full enterprise reuse no locking system
Allow developers to have full control Bedrock 2.0 - pRetainTempObj A new parameter has been added to process that create views called pRetainTempObj
It determines whether views and subsets created as part of the process should be deleted
The default is that the views and subsets created will be deleted as part of the Epilog
Used in Data.Clear, Data.Export & Data.Copy
The names for views are now totally random: random number + time stamp Bedrock 2.0 - pRetainTempObj Bedrock.Cube.Data.Clear
Replaces Bedrock.Cube.Data.ZeroOut, it should be used instead.
Bedrock.Cube.Data.ZeroOut was kept for backwards compatibility
Uses Bedrock.Cube.View.Create to create the clear out view
Uses the ViewCreate logic to export data to file
Replacement for Bedrock.Cube.Data.ExportToFile Bedrock 2.0 – Data P&L Sales COGS OPEX P&L
allocation HR Traditional Approach Modular Approach Presented at Cubewise IBM Cognos TM1
User Conference 2012
Brussels Challenged by Complexity and