Cognos Powerplay Transformer Cubes - Time Dimension - Date - Week - Fundamental Tutorial - Part-4-of-30

For Details: Visit: htt://www.bharaticonsultancy.in
http://bharatidwconsultancy.blogspot.com


Creating a Cognos Time Dimension - Date and Week Level:

This is second part of creating Time Dimensions. Please watch the previous video to create a Time Dimension.


1- Open a Cognos Powerplay Transformer model.
2- Right click the Time Dimension and click on Insert Level.
3- Set Name as Week. Select the source as Date and Check the Unique Level selection box.
4- Click on the "Time" Tab. Select the Date Function as Week. You can see the Time Level Ranking automatically Set to 40.

By Default Cognos sets Time Level Ranking for
Year --> 10,
Quarter -->20
Month -->30
Week --> 40 and
Date --> 50

5- Click on OK and you can see the week level getting created.
6- Similarly Create another level for Date
7- Generate Categories and see Time Heirarchy.
8- Clicking on Show Diagram, now you will find the Year --> Quarter --> Month --> Week--> Date Levels.


SO THATS IT.....

Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.

IBM Cognos Powercube Basic free Tutorial for Beginners,

IBM Cognos Powerplay Self Paced Learning Tutorial for Beginners, 

Cognos Powerplay Transformer Cubes basic fundamentals , IBM Cognos Powerplay Certification, IBM Cognos Powerplay Online Free Tutorial for Beginners, 

Visit blog for detailed steps.

http://bharatidwconsultancy.blogspot.com/

Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.

CONTACT for remaining videos in HD

Bharati DW Consultancy 

cell: +91-8082112148

email:  info@bharaticonsultancy.in

bharati.dwconsultancy@gmail.com 

website: http://bharaticonsultancy.in/

Cognos Powerplay Free Online Basic Self Paced Tutorial - Transformer Cubes

Create First Cognos Powerplay Transformer Cubes - self paced free online Tutorial:

Cognos Transformer is a tool to create Cognos Multidimensional cubes (MOLAP) model; Also, known as Cognos powerplay cubes.
This tool creates a metadata model file with .mdl extension, which generates a physical cube with .mdc extension.

Transformer cubes store data in .mdc file.

Lets create our first Cognos Powerplay Transformer cube.

High level Steps:
Create a Datasource.
Create Dimensions.
Add Levels to Dimensions.
Add Facts.
Inserting a PowerCube.
Create the Powercube: (Inserting data in the cube)
Publishing the cube on Cognos Server.
Accessing the Cube on Cognos Server.


Pre-requisite: You should have Cognos Transformer client installed on your machine and connected to the Cognos server.
We will create our first cube using a .csv file. Keep this file handy.

Detailed Steps:
Create a Datasource:
1- Open the Cognos Transformer Client.
2- Click on Create a new model.
3- Give a name of model, MyModel. Click Next.
4- Give a name for the datasource. From the datasource type, select Delimited field text with column titles.
5- Click Next; click Browse and navigate to the .csv file and click next.
6- Uncheck Run Autodesign and click finish.
7- You have successfuly created a datsource.

Create Dimensions:
8- A Dimension consists of one or multiple Hierarchy and a Hierarchy comprises of one or more Levels.
9- Lets create a dimension. Right Click on Dimension Map on top and select Insert Dimension.
10- Give a name to the dimension, Customer Geography Dimension.
11- Keep everything default for now and click on Ok.
12- Similarly, Insert Product Dimension.

Add Levels to Dimensions:
13- Open the datasource and drag and drop Country, City and Customer Name in the Customer Geography Dimension.
14- In the Product Dimension, drag and drop Product Category, Product Type and Product Name.

Please note: This is basic cube, please see further videos; we will use Customer Code and Name both in the Customer level; similarly for Product.


Add Facts.
15- A cube contains atleast a Fact.
16- From the datasource, drag and drop Sales Amount and Sales Quantity into the Facts Area, next to the Datasource.

Inserting a PowerCube:
17- Right click the Powercubes area, click on Insert Powercube.
18- Mention PowerCube name as MyCube.
19- Keep everything default for now and click on Ok.

Create the Powercube: (Inserting data in the cube)
20- Right click on the powercube.
21- Click on Create Selected PowerCube.
22- Cube is successfuly created.

Publishing the cube on Cognos Server:
23- Right the cube and select Publish Powercube as datasource and package.
Keep all default values. We will see the details in the later videos.
Please note, there are other methods of creating a Cube datasource and package; Look at video: Publishing a Cognos Transformer cube / Cognos Powercube.

24- Enter your credentials to connect to the Cognos Server.
25- Click on Ok.

Accessing the Cube on Cognos Server:
26- Logon to the Cognos Portal.
27- Goto Launch and select Analysis Studio.
28- Click on the Package for MyCube.
29- Click on Blank Analysis.
30- Drag and Drop Customer Geography Dimension on the Rows and Product Dimension on the Columns.
31- Drag and Drop Sales Amount in the Intersection of Crosstab.
32- Check the drill up and drill functionality.

So thats it....

Cognos Cubes - Creating Time Dimension Part-3 of 30

For Details: Visit: htt://www.bharaticonsultancy.in
http://bharatidwconsultancy.blogspot.com


Creating a Cognos Time Dimension:

1- Open a Cognos Powerplay Transformer model.
2- Right click the Dimension Map- area, and click on Insert Dimension.
3- Give a name to this Dimension and then select the Dimension type as Time.
4- Click on the "Time" Tab. Select the date column, on which this dimension will be based on.
5- Click on OK and You can see a Time Dimension getting created.
6- Generate Categories and see Time Heirarchy.
7- Clicking on Show Diagram, you will find the Year --> Quarter --> Month Levels.
8- Watch out in the Next video - steps to create Week and Date levels.

SO THATS IT.....

Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.

IBM Cognos Powercube Basic free Tutorial for Beginners,

IBM Cognos Powerplay Self Paced Learning Tutorial for Beginners, 

Cognos Powerplay Transformer Cubes basic fundamentals , IBM Cognos Powerplay Certification, IBM Cognos Powerplay Online Free Tutorial for Beginners, 

Visit blog for detailed steps.

http://bharatidwconsultancy.blogspot.com/

Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.

CONTACT for remaining videos in HD

Bharati DW Consultancy 

cell: +91-8082112148

email:  info@bharaticonsultancy.in

bharati.dwconsultancy@gmail.com 

website: http://bharaticonsultancy.in/

Creating Dimensions Cognos Powerplay Transformer Cubes (using Flat File): Part-2 of 30

Creating Dimensions Cognos Powerplay Transformer Cubes (using Flat File):

Using Single Flat File:
1- Open the Cognos Powerplay Transformer. Create a New Model.
2- Right click the datasource tab- area, and click on New Datasource.
3- Select source as flat file SalesData.csv
4- Now, create the dimensions & levels. There are multiple ways to create a dimension.
5- Lets create Customer Geo Dimension: Right click the dimension map. Insert Dimension.
6- Give a name to the dimension: Customer Geo Dimension: Drag and drop Country & City
7- Right click the Dimension area and Insert Level. Set source as Cust_id.
8- Next we need to set Label.
9- Click : select label as Customer Name. Source as Customer Code.
10- Now create Product Dimension --> Product Category -- Product Type -- Product
11- Set Product Code as Source and Product Name as Label for PRODUCT LEVEL.
12- Drag Sales Amount and Sales Quantity in the Measures Section.
13- Now we need to create cube.
14- Right click Cube Tab Area. Insert Powercube; Give a name. It is stored as .mdc. Set a path.
15- Right click again the powercube and create powercube.
16- The cube is generated successfully.

SO THATS IT....

Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.
IBM Cognos Powercube Basic free Tutorial for Beginners,
IBM Cognos Powerplay Self Paced Learning Tutorial for Beginners,
Cognos Powerplay Transformer Cubes basic fundamentals , IBM Cognos Powerplay Certification, IBM Cognos Powerplay Online Free Tutorial for Beginners,

Visit blog for detailed steps.
http://bharatidwconsultancy.blogspot.com/

Cognos Powerplay OLAP Transformer Cube, Cognos Transformer Cube, Cognos Cubes, Cognos Powerplay, Cognos Transformer, Cognos OLAP.

CONTACT for remaining videos in HD

Bharati DW Consultancy
cell: +91-8082112148
email:  info@bharaticonsultancy.in
bharati.dwconsultancy@gmail.com
website: http://bharaticonsultancy.in/

Cognos TM1- Basic Self Paced Tutorial for Beginners - Turbo Integrator

Informatica Data Quality - Reference Table Analyst Tool - Part 6 of 10

Informatica Data Quality Tutorial - Creating Rules Analyst Tool Part 4 ...

Cognos 10 Tutorial Video

IBM COGNOS SELF LEARNING TUTORIAL VIDEOS:

1 Cognos 10 Training - Report Studio Basics - Part 1 of 30
    http://www.youtube.com/watch?v=iPumj-PVAYE

2 Cognos 10 Training - Creating Prompts  - Part 2 of 30
    http://www.youtube.com/watch?v=3uUYPUt0pUk

3 Cognos 10 Training - Creating Cascading Prompts  - Part 3 of 30
    http://www.youtube.com/watch?v=n10hPVveIHc

4 Cognos 10 Training - Drill Thru Definition  - Part 4 of 30
    http://www.youtube.com/watch?v=z0_dUoZfEG0

5 Cognos 10 Training - Master Detail Report  - Part 5 of 30
    http://www.youtube.com/watch?v=yFWscNj7sgU

6 Cognos 10 Training - Advanced RS - Creating Joins  - Part 6 of 30
    http://www.youtube.com/watch?v=7xv7Rl33lNA

7 Advanced RS - Creating Unions - Intersect  - Part 7 of 30
    http://www.youtube.com/watch?v=ae2tnqsif-0

8 Cognos 10 Training - Creating Dashboards  - Part 8 of 30
    http://www.youtube.com/watch?v=YlBYDsbrbrg

9 Cognos 10 Training - Conditional Formating-Boolean  - Part 9 of 30
    http://www.youtube.com/watch?v=hk74GC8IqJg

10 Cognos 10 Training - Conditional Formating-String   - Part 10 of 30
    http://www.youtube.com/watch?v=Ooqxm9DfB84

11 Cognos 10 Training - Report Scheduling  - Part 11 of 30
    http://www.youtube.com/watch?v=zatzcA6hW20

12 Cognos 10 Training - Advanced RS - Dynamic Grouping  - Part 12 of 30
    http://www.youtube.com/watch?v=aNUjjxyHazo

13 Cognos 10 Training - Creating Datasource  - Part 13 of 30
    http://www.youtube.com/watch?v=FLHj9McKpO8

14 Cognos 10 Training - FM Project RMR  - Part 14 of 30
    http://www.youtube.com/watch?v=0GYhaGxeWLw

15 Cognos 10 Training - FM Data Level Security  - Part 15 of 30
    http://www.youtube.com/watch?v=oeZw4HrNSG0

16 Cognos 10 Training - Advanced FM - Using Scripts  - Part 16 of 30
    http://www.youtube.com/watch?v=hdYuFHchM54

17 Cognos 10 Training - FM Dimensional Model - DMR  - Part  17 of 30
    http://www.youtube.com/watch?v=kZu5Na0QPNo

18 Cognos 10 Training - Calculations - Filters FM  - Part 18 of 30
    http://www.youtube.com/watch?v=WQFSx6FVwg8

19 Cognos 10 Training - Administration Deployment  - Part 19 of 30
    http://www.youtube.com/watch?v=WYiNjiOw6qM

20 Cognos 10 Training - Creating Security Groups  - Part 20 of 30
    http://www.youtube.com/watch?v=vA33qalbYTg

21 Cognos 10 Training - Restoring Sample SQL Database  - Part 21 of 30
    http://www.youtube.com/watch?v=YCvq9b2Olj8

22 Active Reports - Data Toggle Button Bar  - Part 22 of 30
    http://www.youtube.com/watch?v=Zi_mFIW8k7Y

23 Active Reports - Data Tab Control Filter & Select  - Part 23 of 30
    http://www.youtube.com/watch?v=FJc2FE0uu4w

24 Cognos 10 Training - Business Insight & Advanced - Part 24 of 30
    http://www.youtube.com/watch?v=6H2AzryYWLQ

25 Cognos 10 Training - FM Advanced Prompts &Session Parameters P-25 of 30
    http://www.youtube.com/watch?v=oveM0MV_u1w

26 Cognos 10 Training - FM Advanced Parameter Maps Part 26 of 30
    http://www.youtube.com/watch?v=6doWLvl7x58

27 Cognos 10 Training- Javascript Default Date Prompt Part 27 of 30
    http://www.youtube.com/watch?v=STHJVFTbXIc

28 Cognos 10 Training - Performance Tuning Prompt Page Part 28 of 30
    http://www.youtube.com/watch?v=FY-oGgv6BMU

Cognos 10 BI Training in Mumbai

Cognos 10 BI Training in Mumbai:

Whats new Cognos 10 BI
Overview of Business Intelligence
• What is Business Intelligence
• Why is BI Important and where can we use it
• Components of BI
• Business Intelligence Roadmap

Overview of Data Warehousing
• What is Data Warehouse, Why do we need it
• Data Warehouse Architecture and its components
• Define Star Schema – Fact and Dimensions
• Understand OLTP and OLAP Systems

Overview of Cognos 10 BI and Architecture
• Introduce Cognos 10 BI
• Whats new Cognos 10 BI
• Examine the different studios in Cognos 8 BI
• Identify the different data sources within the studios
• Highlight key cap abilities of Cognos 8 BI
• Understand Cognos Multi Layered architecture

Cognos 10 Installations and Configuration
• Installing Cognos 10
• Install Framework Manager
• Install Cognos BI Application
• Setting up the Environment
• Configuring Cognos 10
• Setting up Samples in Cognos 10
• Uninstalling Cognos 10

Cognos 10 BI Administration
• Create and Modify a Data Source
• Create Database backups
• Understand Roles, Users and Groups
• Specify Permission Settings

Cognos 10 Connection Administration
• What is Cognos Connection
• Examine Cognos Connection UI elements , Create a URL, Login, Logoff
• Entry Properties: General Properties, Permissions, Report, Query, Analysis, Job, Agent and Page Properties
• Navigation- Public and Private Folder
• Open reports with Report Name, Go to Links, Run Reports from a View
• Run Reports- Prompt Pages, Printing a report and Open in Excel
• View the run history of a report and Historical Reports
• Closing and Creating Quick links to Reports , My Folder Shortcut and Browser Bookmark
• Personalize Cognos Connection
• Backups- Export of Cognos, Content Store or select items for Backups
• Restore an exported Backup
• Create and Customize a Page and share a single page with Multiple Users

Cognos 10 Query Studio
• Introduction to Query Studio
• Create Reports (List, Grouped List, Crosstab, Charts)
• Changing the Appearance of Reports (Format)
• Sorting and Grouping
• Filters and Prompts
• Subtotals and Calculations
• Run and Manage Reports
• Drill Through reports

Cognos 10 Analysis Studio
• Introduction to Analysis Studio
• Creating a Basic Analysis
• Working with data in Crosstab
• Exploring Data
• Limiting Data
• Calculating Data
• Sharing Data

Cognos 10 Report Studio
• Introduction to Report Studio
• Report Studio User Interface
• Creating, Save and Run Reports
• Report Templates
• Managing Reports
• Types of Reports
• Active Reports
• List Reports
• Crosstab Reports
• Charts
• Formatting a Report
• Report Layout Guidelines
• Fonts, Styles, Header, Footer and Borders
• Insert objects
• Swap Columns and Rows
• Working with Data
• Filters, Parameters and Prompts
• Sorting and Grouping
• Subtotals and Calculations
• Working with Queries
• Working with Reports
• Managing changes in the Package
• Conditional Formatting
• Drill-through Reports
• Drill-up/Drill-down Reports
• Master-Detail Reports
• Scheduling Reports

Cognos 10 Framework Manager
• Introduction to Framework Manager
• Framework Manager Basics
• User Interface, Navigation, Objects
• Planning the project and data model. Framework Manager Workflow
• Naming Conventions for objects in a project
• Designing Project
• Create project
• Importing Metadata from one and more sources
• Exporting Metadata
• Data Sources
• Working with Data Source Connections
• Create and Modify Data Sources
• Improve Performance by setting Query Processing Type
• Preparing Relational Meta data for use in Reports
• Verifying Relationships
• Working with Dimensions
• Working with Query Subjects- Data, Model and Stored Procedure Query Subject
• Working with Query Items- Set Usage and Aggregate Property
• Making Metadata Available to Report Authors
• Verify Model
• Set Governors
• Improving Performance
• Create or Modify Package
• Controlling access to Metadata
• Explore Package
• Publish Package
• Guideline for Modeling Metadata
• Best Practices , Presentation and Database layers
• Merge Metadata
• Perform Calculations and Filters

Creating Dimensions Cognos Powerplay Transformer Cubes - Tutorial 2-of-30

Creating Dimensions Cognos Powerplay Transformer Cubes (using Flat File):
Using Single Flat File:
1- Open the Cognos Powerplay Transformer. Create a New Model.
2- Right click the datasource tab- area, and click on New Datasource.
3- Select source as flat file SalesData.csv
4- Now, create the dimensions & levels. There are multiple ways to create a dimension.
5- Lets create Customer Geo Dimension: Right click the dimension map. Insert Dimension.
6- Give a name to the dimension: Customer Geo Dimension: Drag and drop Country & City
7- Right click the Dimension area and Insert Level. Set source as Cust_id.
8- Next we need to set Label.
9- Click : select label as Customer Name. Source as Customer Code.
10- Now create Product Dimension --> Product Category -- Product Type -- Product
11- Set Product Code as Source and Product Name as Label for PRODUCT LEVEL.
12- Drag Sales Amount and Sales Quantity in the Measures Section.
13- Now we need to create cube.
14- Right click Cube Tab Area. Insert Powercube; Give a name. It is stored as .mdc. Set a path.
15- Right click again the powercube and create powercube.
16- The cube is generated successfully.
SO THATS IT....

Basic Cognos Powerplay Transformer Cubes - Tutorial 1-of-30

Create First Cognos Powerplay Transformer Cubes - Tutorial:
Cognos Transformer is a tool to create Cognos Multidimensional cubes (MOLAP) model; Also, known as Cognos powerplay cubes.
This tool creates a metadata model file with .mdl extension, which generates a physical cube with .mdc extension.
Transformer cubes store data in .mdc file.
Lets create our first Cognos Powerplay Transformer cube.
High level Steps:
Create a Datasource.
Create Dimensions.
Add Levels to Dimensions.
Add Facts.
Inserting a PowerCube.
Create the Powercube: (Inserting data in the cube)
Publishing the cube on Cognos Server.
Accessing the Cube on Cognos Server.

Pre-requisite: You should have Cognos Transformer client installed on your machine and connected to the Cognos server.
We will create our first cube using a .csv file. Keep this file handy.
Detailed Steps:
Create a Datasource:
1- Open the Cognos Transformer Client.
2- Click on Create a new model.
3- Give a name of model, MyModel. Click Next.
4- Give a name for the datasource. From the datasource type, select Delimited field text with column titles.
5- Click Next; click Browse and navigate to the .csv file and click next.
6- Uncheck Run Autodesign and click finish.
7- You have successfuly created a datsource.
Create Dimensions:
8- A Dimension consists of one or multiple Hierarchy and a Hierarchy comprises of one or more Levels.
9- Lets create a dimension. Right Click on Dimension Map on top and select Insert Dimension.
10- Give a name to the dimension, Customer Geography Dimension.
11- Keep everything default for now and click on Ok.
12- Similarly, Insert Product Dimension.
Add Levels to Dimensions:
13- Open the datasource and drag and drop Country, City and Customer Name in the Customer Geography Dimension.
14- In the Product Dimension, drag and drop Product Category, Product Type and Product Name.
Please note: This is basic cube, please see further videos; we will use Customer Code and Name both in the Customer level; similarly for Product.

Add Facts.
15- A cube contains atleast a Fact.
16- From the datasource, drag and drop Sales Amount and Sales Quantity into the Facts Area, next to the Datasource.
Inserting a PowerCube:
17- Right click the Powercubes area, click on Insert Powercube.
18- Mention PowerCube name as MyCube.
19- Keep everything default for now and click on Ok.
Create the Powercube: (Inserting data in the cube)
20- Right click on the powercube.
21- Click on Create Selected PowerCube.
22- Cube is successfuly created.
Publishing the cube on Cognos Server:
23- Right the cube and select Publish Powercube as datasource and package.
Keep all default values. We will see the details in the later videos.
Please note, there are other methods of creating a Cube datasource and package; Look at video: Publishing a Cognos Transformer cube / Cognos Powercube.
24- Enter your credentials to connect to the Cognos Server.
25- Click on Ok.
Accessing the Cube on Cognos Server:
26- Logon to the Cognos Portal.
27- Goto Launch and select Analysis Studio.
28- Click on the Package for MyCube.
29- Click on Blank Analysis.
30- Drag and Drop Customer Geography Dimension on the Rows and Product Dimension on the Columns.
31- Drag and Drop Sales Amount in the Intersection of Crosstab.
32- Check the drill up and drill functionality.
So thats it....

Cognos 10 Training - Performance Tuning Prompt Page Part 28 of 30

Cognos TM1- Creating Dimensions using Turbo Integrator TI -c- Part 3 of 27

Informatica 8.5 - Running Windows & UNIX Commands - Part 16 of 20

Cognos TM1- Creating Dimensions- Part 2 of 27

Cognos 10 Tutorial (playlist)

Informatica Training - Bharati DW Consultancy (playlist)

Creating Dimensions IN TM1 using Turbo Integrator Process

Creating Dimensions in TM1 using Turbo Integrator Process
 There are 3 ways to create Dimensions
        a. Manual Insert Elements & Dimension
        b. Excel / Copy Paste method
        c. Through TM1 Turbointegrator Process (TI)

Steps (C- Through TM1 Turbointegrator Process (TI) ):
Open the BDCS Data Server
i. Click on Processes
ii. From the Panel select Data Source, Click on Text and Navigate to Product.csv file

iii. Focus on the below area of screen and confirm that v1 is Product and v2 is Product Type and v3 as All Product
iv. Click on Variable tab and rename V1 as vProducts, V2 as Product Types and v3 as Total Products
v. Select Contents as Element for Product and Consolidation for other two
vi. From the Maps Tab in the Dimensions Create a New Dimension known as Product (Products) at the end Element Order should be make as Automatic by Hierarchy
vii. Click on consolidations Tab, make Product as a Child for Product Type and make ProductType as Child for TotalProducts.
viii. Click on the advanced tabs and make sure to validate/Click on all the Tabs.
ix. Save the Process as CreateProductcsv
x. Run the Process
xi. Validate Elements in Products Dimensions
xii. Similarly Create the Channel Dimensions and Process.

SO THATS IT......

Creating Dimensions in Cognos TM1

Creating Dimensions in TM1
 There are 3 ways to create Dimensions
          a. Manually Insert Elements & Dimension
          b. Excel / Copy Paste method
          c. Through TM1 Turbointegrator Process (TI)

Let's create Dimensions in TM1.
Steps (a- Manually Insert Elements & Dimension):
Open the BDCS Data Server
1. Right Click on Dimensions and select New Dimensions
2.  It opens up a Dimensions Editor -
(It is an interface to create or order/reorder the Elements of the Dimensions

3. Click on Edit > Click on Insert Element
4. Set 3 Facts,  as shown
        a. Unit Sales Prices
        b. Unit Cost
        c. Margin
5. Save and Give a Name to Dimension as Sales_Measures
6. Again Click on Edit -> Click on Insert Element
7. Set 2 Elements
    a. Budget Versions 1
    b. Budget Versions 2
8. Save and Give a Name to Dimension as Versions


Steps (b- using Dimension Worksheets Excel / Copy Paste method):
 Open the BDCS Data Server
1. Right Click on Dimensions and select New Dimensions
2. From Excel Sheet, Notepad etc. Copy the Elements (Jan, Feb… Dec) and Paste it in Dimension Editor
3. Create Five New Elements
     i. Qtr1
     ii. Qtr2
     iii. Qtr3
     iv. Qtr4
     v. Total Year

4. Select the first three months. Drag and drop them in Qtr1. Click on Set Dimensions Order.
5. Click Qtr1 and 3 children of Qtr1 and drop it under Total Year. Click on Set Dimensions Order.
6. Repeat the above two steps for the remaining Qtrs
7. Save the Dimensions as Months
8. Dont forget to Click on Set Dimensions Order *****

FOLLOW NEXT POST FOR TM1 Turbointegrator Process (TI)

SO THATS IT......

Advanced Framework Manager Model - Using Scripts

Advanced Framework Manager Model - Using Scripts
Framework Manager Model maintains a log of the activities we do while creating a model.
We can utilise the script to get the change log.
These scripts can also be used for rebuilding the Framework Manager, while debugging model issues.
                 
STEPS:
1- open the Framework Manager Project for RMR.
2- From the Project Menu --> View Transaction History
3- Check the logs.
4- Select only steps till database layer creation. We exclude the presentation Layer steps;
5- Save it as script.
6- Close the project.
7- Create a new blank project.
8- From the Projects --> Run script.
9- Accept the changes.
10- Save the Project....
SO THATS IT...