Home
Videos uploaded by user “Data Labs India Solutions Pvt Ltd”
Creation of Smartlist in Oracle Hyperion
 
07:35
Administrators use Smart Lists to create custom drop-down lists that users access from form cells. When clicking in cells whose members are associated with a Smart List (as a member property), users select items from drop-down lists instead of entering data. Users cannot type in cells that contain Smart Lists. Smart Lists display in cells as down arrows that expand when users click into the cells. Perform these tasks to create and administer Smart Lists: • Define Smart Lists, described here. • Associate Smart Lists with members. • Select dimensions for which Smart Lists are displayed. • Optionally: • Use Smart List values in member formulas. • Set how #MISSING cells associated with Smart Lists display in forms. • Synchronize Smart Lists in reporting applications
Creating Classic Application  in Oracle Hyperion Planning
 
11:46
Oracle Hyperion Planning is a budgeting and forecasting application that integrates financial and operational planning processes and that aims at improving business predictability. Data sources link the relational database to the Essbase server. You must create a data source when you create an application. Oracle Hyperion Planning provides an in-depth look at business operations and its related impact on financials, by closely integrating financial and operational planning models.
Creating a  Cube in SSAS
 
08:09
SQL Server Analysis Services (SSAS) is the technology from the Microsoft Business Intelligence stack, to develop Online Analytical Processing (OLAP) solutions. In simple terms, you can use SSAS to create cubes using data from data marts / data warehouse for deeper and faster data analysis. Cubes (Analysis Services) A cube is a set of related measures and dimensions that is used to analyze data. A measure is a fact, which is a transactional value or measurement that a user may want to aggregate. Measures are sourced from columns in one or more source tables, and are grouped into measure groups. A Data source is a connection that represents a simple connection to a data store; it includes all tables and views in the data store. A data source has project scope, which means that a data source created in an Integration Services project is available to all the packages in the project. A data source can be defined and then referenced by connection managers in multiple packages. This makes it easy to update all connection managers that use that data source. A project can have multiple data sources, just as it can have multiple connection managers A Data source view contains the logical model of the schema used by Analysis Services multidimensional database objects—namely cubes, dimensions, and mining structures. A data source view is the metadata definition, stored in an XML format, of these schema elements used by the Unified Dimensional Model (UDM) and by the mining structures
Build Metadata into Dimensions by using Rule Files in Oracle Hyperion
 
11:35
Using Rule files is the best way of build metadata into ESSBase dimension.By using Rule files you can ignore certain fields in the data source and Manage header information (for ex: ignore and add header) and Change the order of fields by moving, joining, splitting or creating fields
Loading Data in Oracle Hyperion ESSBase
 
07:33
Loading data is the process of adding data values to an database from a data_source. If the data source is not perfectly formatted, you need a data load rules files to load the data values. If you are using a rules file, you must set up the data source in your local disk, Each record in the data source must have the same number of data value fields to perform a data load. If data values are missing, the data load processes incorrectly.
Creation of Menus in Oracle Hyperion Planning
 
06:32
Menus are the shortcuts that display forms or launch a business rule to perform planning calculation and we can also define menus as shortcut links by using which we directly navigate to Business Rules, Data Forms. As an Administrator we can create menus and incorporate them on simple click. When we are in one data form we can automatically navigate to another data form on single click.
Creation of Model in SAP BPC
 
03:43
A model is built inside an environment. It is a collection of several dimensions and is designed to meet the planning and consolidation requirements of an organization. The model is where you interface to plan, consolidate, and report data. For instance, you might have a model for a cost center planning application to compare actuals versus plan based on cost centers or a model for legal consolidations that reports your organization’s financial results.
Working with Calculation Manager in Oracle Hyperion Planning
 
11:17
Service Administrators and Power Users who have been assigned to create business rules use Oracle Hyperion Calculation Manager to create, validate, deploy, and administer calculations that solve business problems in Oracle Hyperion Planning. Initially, only Service Administrators can access business rules. The Service Administrator grants access to the rules and rule sets to users who need to access them
Oracle Hyperion Planning For Beginners
 
09:25
Hyperion Planning is an excel and web-driven planning, budgeting and forecasting application to help connect operational assumptions to financial outcomes. Hyperion Planning sits in an application server (relational layer that sits on top of ESSBase); between the ESSBase database and the client tools that work with it; integrating financial and operational planning processes; leading to improved business predictability. Planning does so by leveraging ESSBase multidimensional data model as well as standard relational database management platforms.
Oracle Hyperion ESSBase Overview For Beginners
 
07:23
Oracle ESSBase is an OLAP (Online Analytical Processing) Server that provides an environment for deploying pre-packaged applications or developing custom analytic and enterprise performance management applications. With a rapid application development environment, Oracle ESSBase enables business users to quickly model complex business scenarios. Oracle ESSBase provides adaptable data storage mechanisms for specific types of analytic and performance management applications, thereby ensuring sub-second response times regardless of the complexity of the analytics.
Creation of Users, Groups in Oracle Hyperion Planning
 
09:51
User directories, Native Directory and corporate user directories--are the source for users. The authentication and the authorization processes utilize user information. Groups are containers for users or other groups. You can create and manage Native Directory groups from Shared Services Console. You can provision the groups to grant permissions for EPM System products registered with Shared Services.
Creation of Dimension in SAP BPC
 
07:33
Dimensions are the building blocks and consists out of dimension members.Some are mandatory such as category, entity, time, account. This also depends the application type.
Creation of Task List in Oracle Hyperion Planning
 
06:52
Task Lists are used to show alert messages regarding the status to be completed in stipulated amount of time and helps users to navigate through application for ensuring complete data collection. We can also modify the task lists for adding our own tasks, entering data in forms and as well as for running business rules. Administrators use it for instructing the power users to create forms for the application and also defines who can access it
Creating  Dimension and Fact Tables in MSBI
 
03:59
A dimension table is a table in a star schema of a data warehouse. A dimension table stores attributes, or dimensions, that describe the objects in a fact table. The fact table contains business facts(or measures), and foreign keys which refer to candidate keys (normally primary keys) in the dimension tables.  Measures. When you first connect to a data source, Tableau assigns any fields that contain quantitative, numerical information (that is, fields where the values are numbers) to the Measures area in the Data pane. When you drag a field from the Measures area to Rows or Columns, Tableau creates a continuous axis.
MRP with IBM Planning Analytics
 
05:04
Material requirements planning (MRP) is a vital component in the supply chain. It acts as the system’s bridge between master planning and production. MRP helps determine requirements and maintain priorities. • MPS generates planned production orders for finished products • MPS takes demand plan as key input along with planning parameters and inventory and order information. • MRP calculates raw materials and sub-assemblies based on MPS planned orders. • MRP generates planned production orders and planned purchase orders to meet demand for products in a timely manner.
Creation of Hierarchy in SAP BPC
 
03:52
Hierarchies are defined by the ParentHx property. It's possible to define more than 1 hierarchy by using ParentH2, ParentH3... The advantage of using hierarchies is that BPC automatically calculates the value of the levels above (parent members).
SAP BPC Budgeting
 
04:53
SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver, provides a unified planning suite to address a wide range of business issues. Now fully supported by the SAP BW on HANA platform, BPC 10.1 provides deeper integration with SAP NetWeaver and can leverage the platform’s Integrated Planning (IP) and Planning Applications Kit (PAK) framework. The introduction of SAP Cloud for Planning builds upon this by offering the ability to roll out a public cloud planning application to strategic business units that can plug into the central BPC plan
Time Series Forecasting With IBM Planning Analytics Powered by R
 
07:54
 R has extensive facilities for analyzing time series data.  R language uses many functions to create, manipulate and plot the time series data.  It describes the creation of a time series, seasonal decomposition, modeling with Exponential and ARIMA models, and forecasting with the forecast package.  Time series analysis and forecasting is one of the key fields in statistical programming. It allows you to see patterns in time series data, model this data, and finally make forecasts based on those models  These are statistical techniques used when several period data for a product or product line are available and when relationships and trends are both clear and relatively stable.  Now, a time series is a set of chronologically ordered points of raw data for example, a division’s sales of a given product, by month, for several years.  Time series analysis helps to identify and explain: • Any regularity or systematic variation in the series of data which is due to seasonality. • Cyclical patterns that repeat any two or three years or more. • Trends in the data.
SAP BPC Overview For Beginners
 
05:06
Spend more time growing your business and less time closing the books – with SAP Business Planning and Consolidation. The BPC software delivers planning, budgeting, forecasting, and financial consolidation capabilities in a single application. Easily adjust plans and forecasts, speed up budget and closing cycles, and ensure compliance with financial reporting standards.
Creation  Of Environment in SAP BPC
 
03:34
SAP BPC helps in automating and streamlining business forecast, planning, and consolidation activities in your organization. Environment (V10) is a set of models, contained in one SAP BW cube. It is comparable with an application set.
Feedmill Supply Chain Automation Introduction
 
04:46
PLANT CONTROL SYSTEM: 1. For the control system the Simatic controllers are used. The different control units are connected to this PLC by Profibus DP 1.5MB or Profinet. The signals from the process (motors, flaps, slides, level probes, valves etc.) and also the power section (contactors, frequency converters etc.) are mainly connected to the I/O modules at Profinet. 2. At operating station there are one master PC (with a standby PC, if ordered) located in the control room. The PC’s have the same installation. In the normal operation one PC runs as master with the software application with the visualization and the control over the database. 3. An Ethernet network (TCP/IP) is used to connect the PLC’s to the PC's. There are Profibus DP and Profinet networks used on the control level. They connect all the I/O terminals via the Profinet as well as the scales and local operator panels via the Profinet to the PLC. 4. The PLC at the control level performs the following main functions: - Execution of the jobs assigned by the PCS - Control and monitoring of the plant - Registration of the production data - Interlocking of all functions not allowed or not possible - Division of job sequences into individual control signals and their automatic execution 5. Production is not possible when PCS is not in operation
Feed Mill Control System
 
06:27
Use of control systems, computers, information technologies for handling different processes and machineries in feed mill industry is described Included engineering works: The following engineering works are included: • Automation concept and planning • Hardware engineering and documentation • Planning for Line arrangement, devices and operation, Interlocking and communication interface • Elaboration of system specifications • Software implementation on computer system, incl. testing • Software implementation on PLC level, incl. testing • Necessary documentation • Preventive Maintenance • Inventory & Production Management
How to create forms and form folders in Oracle Hyperion Planning, in planning
 
09:03
This video represent How to create forms and form folders in Oracle Hyperion Planning, in planning, we create two types of forms 1. Simple Forms and 2. Composite Forms
Budgeting with Oracle Hyperion
 
05:56
The digital economy demands more than traditional spreadsheets and department-oriented planning processes. Truly effective planning needs to seamlessly connect the entire organization. Oracle's planning, budgeting, and forecasting solutions align planning across the enterprise, so that you can develop agile forecasts for all lines of business and respond faster and more effectively to change. • Reduce implementation and ownership costs with packaged public sector functionality • Quickly and accurately create workforce plans and budgets • Reduce budgeting and planning cycles by weeks or months • Improve forecast accuracy by gaining visibility into plan/actuals/budget/forecast comparisons • Reduce the time spent on creating reports and budget book
Loading Meta Data into Oracle Hyperion
 
07:51
his video represents loading Metadata into an application in Oracle Hyperion Planning Application, we have two ways of loading metadata 1. Through manually and then 2. Export Metadata format to Microsoft Excel and Import Metadata from Excel.
Member properties of Account Dimension in Oracle Hyperion Planning
 
08:20
This video represent Member properties of Account Dimension in Oracle Hyperion Planning.
Partions in Oracle Hyperion Essbase
 
11:31
This videos represent Partitions in Oracle Hyperion Essbase. We have three types of Partitions in Essbase. Such as 1. Replicated: copy data from source application to target application, but not up-to-minute. 2. Transparent: copy data from source application to target application, up-to-minute. 3. Linked This video explains how to navigate Replicated partition.
SAP BPC Reporting
 
05:11
SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver, provides a unified planning suite to address a wide range of business issues. Now fully supported by the SAP BW on HANA platform, BPC 10.1 provides deeper integration with SAP NetWeaver and can leverage the platform’s Integrated Planning (IP) and Planning Applications Kit (PAK) framework. The introduction of SAP Cloud for Planning builds upon this by offering the ability to roll out a public cloud planning application to strategic business units that can plug into the central BPC plan
Introduction to IBM Planning Analytics Overview for Beginners
 
08:41
IBM Planning Analytics, powered by IBM TM1, automates and improves your essential planning, budgeting, forecasting and analysis processes. It provides flexible, multidimensional modeling to represent your business, and it delivers self-service analytics for all your business users. From a customizable planning workspace, the solution discovers insights automatically – directly from your data – and can provide the speed, agility and foresight you need to deliver better business results.
create forms and form folders in Oracle Hyperion Planning (Part-2)
 
06:30
This video represent How to create forms and form folders in Oracle Hyperion Planning, in planning, we create: 1.Composite Forms
Activity Based Costing with IBM Planning Analytics
 
09:49
Activity based costing (ABC) assigns manufacturing overhead/indirect costs to products in a more logical manner than the traditional approach of simply allocating costs on the basis of cost drivers. Activity based costing first assigns costs to the activities that are the real cause of the overhead. It then assigns the cost of those activities only to the products that are actually demanding the activities.  Resources consume overhead  Activities consume resources  Customers, products and channels consume activities
Planning with Oracle Hyperion
 
06:40
Oracle Hyperion Planning is a centralized, Excel and Web-based planning, budgeting and forecasting solution that integrates financial and operational planning processes and improves business predictability. Oracle Hyperion Planning provides an in-depth look at business operations and its related impact on financials, by tightly integrating financial and operational planning models. With Oracle Hyperion Planning you can meet your immediate financial planning needs while enabling a platform for future cross-functional expansion and automated process integration. • Reduce planning, budgeting, and forecasting cycles by weeks or months • Improve accuracy of plans and forecasts • Shrink the user learning curve by leveraging a Microsoft Office-based interface • Eliminate time lag between when plans are updated and reports are refreshed • Reduce cost of ownership through superior application deployment, management tools, and packaged data integration • Choose to deploy in the Oracle Cloud, on premises, in a third-party data center, or any combination
MSBI Overview Navigation
 
06:24
MSBI Descrption: MSBI stands for Microsoft Business Intelligence. MSBI is a powerful suite and is composed of tools which help in providing best solutions for Business Intelligence and Data Mining Queries. MSBI empower users to gain access to accurate and up-to-date information for better decision making in an organization. This tool uses Visual studio along with SQL server and offers different tools for different processes which are required in Business Intelligence (BI) solutions. Integration Services is a platform for building high-performance data integration and workflow solutions, including extraction, transformation and loading (ETL) operations for data warehousing. Microsoft Sql server analysis services is the process of converting two dimensional (rows and columns/OLTP) data into multi-dimensional data model (OLTP). This will help you to analyze the large volume of data. We are creating Cubes ,Calculations and MDX query to retervie the data. Some of the advantages are Multi-dimensional analysis, Good performance and Security and so on. Microsoft SQL Server Reporting Services (SSRS) is an enterprise reporting platform supporting traditional and interactive reports delivered over the web or through custom applications. Power BI is a cloud based data analysis, which can be used for reporting and data analysis from wide range of data source. Power BI is simple and user friendly enough that business analysts and power users can work with it and get benefits of it. On the other hand Power BI is powerful and mature enough that can be used in enterprise systems by BI developers for complex data mash-up and modeling scenarios. SharePoint workflows are pre-programmed mini-applications that streamline and automate a wide variety of business processes. Workflows can range from collecting signatures, feedback, or approvals for a plan or document, to tracking the current status of a routine procedure.
Sales & Operations Planning Introduction with IBM Planning Analytics
 
04:52
Sales and operations planning (S&OP) is an integrated business management process through which the executive/leadership team continually achieves focus, alignment and synchronization among all functions of the organization. The S&OP includes an updated forecast that leads to a sales plan, production plan, inventory plan, customer lead time (backlog) plan, new product development plan, strategic initiative plan and resulting financial plan. Plan frequency and planning horizon depend on the specifics of the industry. Short product life cycles and high demand volatility require a tighter S&OP than steadily consumed products. Done well, the S&OP process also enables effective Danilo supply chain management. A properly implemented S&OP process routinely reviews customer demand and supply resources and "re-plans" quantitatively across an agreed rolling horizon. The re-planning process focuses on changes from the previously agreed sales and operations plan, while it helps the management team to understand how the company achieved its current level of performance, its primary focus is on future actions and anticipated results.
Oracle Hyperion ESSBase Part-1
 
05:43
Essbase is a multidimensional database management system (MDBMS) that provides a multidimensional database platform upon which to build analytic applications. Essbase means "extended spreadsheet database" and it is a Online analytical Processing server “Oracle Essbase is the leading multidimensional database system that provides a platform for complex analytical and custom applications. It can be used by end users to analyze their business and to make rapid decisions while providing complex reporting capabilities out of a common toolset.”
Material Requirement Planning Model Building in  IBM Planning Analytics
 
09:59
Material requirements planning (MRP) is a vital component in the supply chain. It acts as the system’s bridge between master planning and production. MRP helps determine requirements and maintain priorities. • MPS generates planned production orders for finished products • MPS takes demand plan as key input along with planning parameters and inventory and order information. • MRP calculates raw materials and sub-assemblies based on MPS planned orders. • MRP generates planned production orders and planned purchase orders to meet demand for products in a timely manner.
IBM Cognos TM1 Budgeting
 
04:44
Learn more about IBM Cognos TM1: http://www.ibm.com/software/products/... Discover how the Cognos TM1 10 can revolutionize your planning and analytics. Watch this webcast to: - See the new personal analytics desktop that enables all types of users to analyze the business, explore different scenarios for action, and share results. - Discover the advancements in user and data scaling that support the most complex planning. - Explore the features that address continuous planning, profitability analysis and other performance management challenges. Want to learn about another exciting development for IBM's world-class financial performance software? Read this IBM white paper about Cognos TM1 and IBM Concert: http://bit.ly/1n6kl06
Simple moving average in R Language
 
05:04
• Simple Moving Average is a method of time series smoothing and is actually a very basic forecasting technique. • It does not need estimation of parameters, but rather is based on order selection. It is a part of smoothing package. • To estimate the trend component of a non-seasonal time series that can be described using an additive model, it is common to use a smoothing method, such as calculating the simple moving average of the time series. • The SMA () function in the “TTR” R package can be used to smooth time series data using a simple moving average. • To use this function, we first need to install the “TTR” R package. Once you have installed the “TTR” R package, you can load the “TTR” R package by typing: library (“TTR”). • You can then use the “SMA ()” function to smooth time series data. To use the SMA () function, you need to specify the order (span) of the simple moving average, using the parameter “n”.
Adding Plan Types and Dimensions in Oracle Hyperion Planning
 
05:45
This video represents , How to add Plan Types and custom Dimensions after creating planning application
MSBI Overview For Beginners
 
10:39
MSBI Descrption: MSBI stands for Microsoft Business Intelligence. MSBI is a powerful suite and is composed of tools which help in providing best solutions for Business Intelligence and Data Mining Queries. MSBI empower users to gain access to accurate and up-to-date information for better decision making in an organization. This tool uses Visual studio along with SQL server and offers different tools for different processes which are required in Business Intelligence (BI) solutions. Integration Services is a platform for building high-performance data integration and workflow solutions, including extraction, transformation and loading (ETL) operations for data warehousing. Microsoft Sql server analysis services is the process of converting two dimensional (rows and columns/OLTP) data into multi-dimensional data model (OLTP). This will help you to analyze the large volume of data. We are creating Cubes ,Calculations and MDX query to retervie the data. Some of the advantages are Multi-dimensional analysis, Good performance and Security and so on. Microsoft SQL Server Reporting Services (SSRS) is an enterprise reporting platform supporting traditional and interactive reports delivered over the web or through custom applications. Power BI is a cloud based data analysis, which can be used for reporting and data analysis from wide range of data source. Power BI is simple and user friendly enough that business analysts and power users can work with it and get benefits of it. On the other hand Power BI is powerful and mature enough that can be used in enterprise systems by BI developers for complex data mash-up and modeling scenarios. SharePoint workflows are pre-programmed mini-applications that streamline and automate a wide variety of business processes. Workflows can range from collecting signatures, feedback, or approvals for a plan or document, to tracking the current status of a routine procedure
Human-Machine Interface (HMI)
 
03:57
Industrial HMI is a human-machine interface (HMI) designed for industrial applications. A human-machine interface encompasses both the hardware and software components necessary for the exchange of information between a human operator and a machine — in this case, an industrial system or industrial machinery or equipment
Basics of PLC (Part-2)
 
04:46
This video explains the various terminals of PLC (Part-2) : Memory designs PLC communication Specifications and Selecting a PLC Working with PLC Programming
Time series Forecasting using simple exponential smoothing in R Language
 
04:13
This video describes you about how we can estimate the level at the current time point using Time series Analysis with R language
IBM Cognos TM1 Planning
 
05:01
Learn more about IBM Cognos TM1: http://www.ibm.com/software/products/... Discover how the Cognos TM1 10 can revolutionize your planning and analytics. Watch this webcast to: - See the new personal analytics desktop that enables all types of users to analyze the business, explore different scenarios for action, and share results. - Discover the advancements in user and data scaling that support the most complex planning. - Explore the features that address continuous planning, profitability analysis and other performance management challenges. Want to learn about another exciting development for IBM's world-class financial performance software? Read this IBM white paper about Cognos TM1 and IBM Concert: http://bit.ly/1n6kl06
Introduction to Supervisory control and data acquisition (SCADA)
 
04:42
Supervisory control and data acquisition (SCADA) is a system of software and hardware elements that allows industrial organizations to: Control industrial processes locally or at remote locations. Monitor, gather, and process real-time data.
Basics of PLC (Part-3)
 
08:51
This video explains the various terminals of PLC (Part-3) : Timers Counters Scanning Ladder diagram Basic logic gates
Transform Finance and Business with IBM Planning Analytics   YouTube
 
00:45
Learn more and try IBM Planning Analytics for free: http://ibm.com/planning IBM Planning Analytics brings self-service analytics to your entire organization and offers all the capabilities you need to transform business and finance in a single solution.
Basics of PLC (Part-1)
 
03:51
This video explains the various terminals of PLC : Definition of PLC Components of PLC Advantages of PLC Basic PLC operation Areas of application
Plan in a Familiar Interface with IBM Planning Analytics   YouTube
 
00:38
Learn more and try IBM Planning Analytics for free: http://ibm.com/planning With IBM Planning Analytics, you can take advantage of the familiar Microsoft Excel interface, where needed, while enjoying all the capabilities of a modern planning and analytics solution.
Perform In depth Analysis with IBM Planning Analytics   YouTube
 
00:45
Learn more and try IBM Planning Analytics for free: http://ibm.com/planning With IBM Planning Analytics, you can explore and analyze data in real time, create sophisticated scenario models and perform in-depth, multidimensional analysis to assess the impact of initiatives and market events.