Search results “Extract attribute value oracle”
PDH Display Format and Attribute Edit-Upload, Oracle Applications Training
This video displays a great feature in Oracle PDH. It shows how to extract specfic items and their attributes into Excel and then modify them and upload the chagnes back into Oracle. This is a Web ADI for Oracle Inventory.
Views: 590 Larry Sherrod
MSSQL - How to Query XML in SQL Server
Common XML XPATH Expressions used in querying XML in SQL Server
Views: 16788 CodeCowboyOrg
Nifi: how to extract attributes from text and route on those attributes
In this example, we read some data from a CSV file, use regular expressions to add attributes, and then route data according to those attributes.
Views: 11322 Alex Woolford
Working with Attribute Dimensions in Hyperion Planning, Essbase, EPBCS and PBCS
Have you ever had a need to group hierarchy rollups as based on characteristic, for example utilizing a tag called “Green” to capture all green-colored “Item” dimension members? How about the prospect of reporting data using such characteristics in Oracle Hyperion Planning, Essbase, Oracle Planning and Budgeting and Cloud Service (PBCS) or Enterprise Planning and Budgeting Cloud Service (EPBCS)? Great news! Both business cases can be satisfied with little effort through the use of attribute dimensions. In this blog post, we’ll discuss the topic of attribute dimensions (hierarchies commonly referred to as “attributes” for short) in detail within the context of PBCS. Sub-topics include how to create and manage attributes, how to integrate them into forms and reports, and how to leverage them in calculations.
Views: 4279 KeyPerformanceIdeas
Get Table Names with Column Names and Data Types in SQL Server - SQL Server Tutorial
In this video ,we will generate the script that will return us all the table names with column names and data type of those columns. We often need this information. Let's say we are going to prepare mapping document for load the data from Source Database to Destination database. We can get the list of all tables with column names and data types from Source Database and Destination Database and then paste in Excel and map the required input columns to output columns for ETL Process. Blog link with scripts used in video http://sqlage.blogspot.com/2015/02/get-all-tables-with-column-names-and.html
Views: 38198 TechBrothersIT
Creating Scenarios with Strategic Modeling in Oracle Enterprise Planning Cloud
This tutorial demonstrates how to create scenarios in Strategic Modeling. First, you see how to view data for selected scenarios. Then you review the choices for creating scenarios such as whether the scenario inherits its values and logic from another scenario. You enter values into your new scenario and evaluate how those values and other values are calculated.
1Z0-558 - Oracle Value Test Chain Planning Exam Management 7 Essentials Questions
For Oracle 1Z0-558 Test Questions and Answers Please Visit: https://www.passeasily.com/1Z0-558.htm Exam Section 1 - Collaboration workbench Questions (Test Coverage 5%) Exam Section 2 - Worksheets Questions (Test Coverage 8%) Exam Section 3 - Series Questions (Test Coverage 8%) Exam Section 4 - Security Test Manager Questions (Test Coverage 12%) Exam Section 5 - Workflow Manager Questions (Test Coverage 14%) Exam Section 6 - Data Model Questions (Test Coverage 10%) Exam Section 7 - Forecast Test Engine Questions (Test Coverage 16%) Exam Section 8 - Integration Questions (Test Coverage 15%) Exam Section 9 – Causal Test Factors Questions (Test Coverage 12%) (1Z0-558 Passing Score): 62% (Number of Test Questions): 70 (Exam Time): 120 minutes 1. Collaboration workbench • Personalize the test Workbench • Configure Workbench using 1Z0-558 Admin tools • Set up and manage Questions Tasks • Set up KPI's • Manage Exam Content Panes 2. Worksheets • Explain Worksheet test elements • Explain different types of Worksheets - Calendar, Content etc • Configure Embedded Worksheets • Use Open With functionality • Create a Waterfall Worksheet • View Test Audit Trail and Notes • Configure Worksheets using the Exam Layout • Set up Worksheets Questions using the Wizard • Explain the Filter Mechanism • Explain the 1Z0-558 Aggregate / Disaggregate concept 3. Series • Configure the test different elements of Series • Configure the Client vs Server Expressions • Use Proportions for 1Z0-558 Series calculations • Use Client Expessions in Exam Series • Configure Series Set up - Graph, Color 4. Security Manager • Create/Modify a User Component • Create /Modify a User • Set up Users with Questions Series restrictions • Set up Users with Level restrictions • Set up Users with Unit restrictions • Set up Test User Profiles • Manage 1Z0-558 User Groups • Set up Worksheets for Open With 5. Workflow Manager • Explain Workflow Manager Step Types • Set up Schedules in Workflow Manager • Manage Workflow Groups • Troubleshoot Exam Errors • View the progress and status of Jobs • Configure Level Methods 6. Data Model • Explain the concept of 1Z0-558 Hierarchy and Levels • Explain the types of Levels • Add a new Item Questions and Location Level • Add a Time Test Level • Add Attributes to Levels • Explain the purpose and use of Attributes • Explain the Mapping of Staging tables • Explain the difference between Upgrade and a New Model • Add UOM and 1Z0-558 Price 7. Forecast Engine • Explain the concept of a Forecast Tree • Explain the structure questions and requirements of a Forecast Tree • Configure a 1Z0-558 Forecast Tree • Explain the concept of Influence Range and Influence Group • Explain the Theoretical Test Engine Models • Explain the application of Engine Models based on Data Quality • Explain the Engine Parameters pre-requisite to an Engine Execution • Create an Engine Profile • Specify the Demand Stream and set up the 1Z0-558 Engine Parameters • Register the Analytical Engine • Execute the Engine using Engine Administrator • Explain the Outputs Exam for the Analytical Engine • Examine the Engine Results • Run a Simulation Exam Scenario
Views: 283 Jhon Harry
Creating Supplemental Data Forms and Entering Data in Oracle Financial Consolidation and Close Cloud
This tutorial demonstrates how to create Supplemental Data forms and enter data in Financial Consolidation and Close Cloud applications. You learn how to create form templates, deploy templates to create forms, and enter data in forms.
SQL Tutorial - 13: Inserting Data Into a Table From Another Table
In this tutorial we'll learn to use the INSERT Query to copy data from one table into another.
Views: 223158 The Bad Tutorials
How to Convert Oracle Spatial to Shapefile 2016
Quickly load an Oracle Spatial database to Esri Shapefile. You’ll see how to query the input table to extract only certain rows for the output Shapefile. You’ll see how to connect to the database, select the table, and execute SQL before, during, or after the translation. We’ll also look at how to modify the schema, including renaming attributes. To learn more, visit http://www.safe.com/how-it-works/?utm_source=youtube&utm_medium=video&utm_campaign=oracle-spatial-shp-format-conversion-vid
Views: 820 FME Channel
How to Create Descriptive Flexfield (DFF) in Oracle Fusion Cloud
This video explains you the features, differences and the steps to create two types - Global and Context Descriptive Flexfield. Enroll for our complete trainings at: www.apps2fusion.com/packages Also, visit us at : http://apps2fusion.com/ Contact us at: [email protected] or +44-207-193-5456 | +1-650-318-5241 Follow Us On: Facebook: https://www.facebook.com/apps2fusion Twitter: https://twitter.com/apps2fusion LinkedIn: https://www.linkedin.com/company/apps2fusion Youtube: https://www.youtube.com/c/apps2fusion
Views: 3922 apps2fusion
Dynamic Power BI reports using Parameters
In this video, Patrick shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. This uses M Functions within Power Query and a second source that has the key values to pull. Then using a gateway to enable refresh. LET'S CONNECT! Guy in a Cube -- https://guyinacube.com -- http://twitter.com/guyinacube -- http://www.facebook.com/guyinacube -- Snapchat - guyinacube -- https://www.instagram.com/guyinacube/ ***Gear*** Check out my Tools page - https://guyinacube.com/tools/
Views: 64730 Guy in a Cube
Extracting Data from Oracle Planning and Budgeting Cloud using Data Management
This tutorial demonstrates how to use Data Management to extract data from Oracle Planning and Budgeting Cloud into a flat file. You create a custom application, add an import format, location, and mapping information to complete the configuration. You create and execute a data load rule to run the import and export process. You can also create a batch file to automate this process using EPM Automate.
Views: 5965 Oracle EPM Tutorials
Attribute Dimensions Do I Have Them How Do I Use Them - Smart View for Essbase Quick Tip
Attribute Dimension Quick tips from HCG Certified Oracle Hyperion instructors. Want to see more? Stay tuned to this youtube channel and visit us at: www.harbinger-group.com for Oracle EPM & BI training, consulting, support and staffing.
Views: 4596 HCGUniversity
Creating Tasks in Oracle Financial Consolidation and Close Cloud
This tutorial demonstrates how to create tasks in Financial Consolidation and Close Cloud applications. You learn how to set up workflow, add attributes and questions, define predecessors, and import tasks.
Blue Prism Video Tutorial | 022 | Automating web applications - Part 1 - Spying HTML elements
In this video we will discuss how to spy the elements on an HTML page in order to automate the web application using Blue Prism and it will give you a detailed walk through on the various attributes. Now get access to BluePrism environment and materials by signing up on RPA Academy (BluePrism authorized partner) and get a $50 discount by using my discount code BP50. Click the below link to get access. https://courses.therpaacademy.com/course?courseid=blue-prism-developer-course---instant-access---live-training
Views: 73458 Busy Ping
Oracle EPBCS: Strategic Modeling
Would you like to move beyond tactical financial planning to long range target setting? Can you quickly perform what-if scenario modeling? Are you still doing financial modeling and impact analysis in spreadsheets? Advanced financial models reveal the impacts of strategic decisions on an organization’s bottom line, balance sheet, cash flow, and shareholder value. However, these models cannot be easily developed or maintained in conventional enterprise planning solutions and spreadsheets. Watch a replay of our webinar featuring the Strategic Modeling product, embedded in Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS), a feature rich financial forecasting and modeling solution that provides a complete integrated and closed loop solution to set targets, perform impact analysis, and present focused financial information. Move from spreadsheets and inefficient modeling of your business performance to modeling with integrity and transparency to minimize risk and create efficiencies that address ever-changing market conditions. Scott Costello, our speaker, provides a demonstration of the Strategic Modeling product, including how to: • Perform on-the-fly “what-if” impact analysis based on dynamic decision variables • Arrive at targets that can then be used within other enterprise performance management processes • Model cash flow implications of debt • Analyze trail feature to visualize model logic • Create freestyle professional quality reports Scott also shows how the Strategic Modeling product integrates strategic planning, treasury and financial modeling activities and how it can be easily deployed and implemented with minimal IT support.
Views: 1570 KeyPerformanceIdeas
how to create value set and DFF hcm fusion
how to create value set and DFF hcm fusion
Views: 6671 hcm fusion
Informatica : Clob Data Type To Blob Data Type Conversion using Java Tranformation
Converting Character Large Object of Source to Binary Large Object of Target using Informatica Java Transformation. For more information please check http://gogates.blogspot.in/2013/09/transfering-clob-data-to-blob-using.html
Views: 5177 Mandar Gogate
Php : How To Search And Filter Data In Html Table Using Php And MySQL Database [ with source code ]
How To Find Data In MySQL Database And Display It In Html Table Using Php Source Code: http://1bestcsharp.blogspot.com/2015/10/php-html-table-search-filter-data-mysql-database.html PHP Programming Tutorials ➜ http://bit.ly/2Lh7zPM PHP And MySQL Tutorials ➜ http://bit.ly/2kdXWot PHP Course For Beginners ➜ http://bit.ly/2GxRodb Web Development Course ➜ http://bit.ly/2ITRQrj visit our blog https://1bestcsharp.blogspot.com/ facebook: https://www.facebook.com/1BestCsharp twitter: https://www.twitter.com/1BestCsharp_ subscribe: http://goo.gl/nRjPKk Share This Video: https://youtu.be/2XuxFi85GTw In this Php Tutorial You will see How You Can Make Search Input Text And Show Data With Input Text Value In Html Table Using MySQL Database And Php . I Use In This Tutorial: - NetBeans IDE . - XAMPP . - PhpMyAdmin . Others Tutorials : Get Select Option Value From MySQL Database Using Php https://www.youtube.com/watch?v=V8sIWh_sdvs How To Populate Html Table From MySQL Database Using Php https://www.youtube.com/watch?v=6goqMwURH9Q How To Use Mysqli Num Rows In Php https://www.youtube.com/watch?v=12L6Sckk8cc How To Use Pdo Row Count In Php https://www.youtube.com/watch?v=F3tqnbDTP3k Insert Update Delete Search Data In MySQL Database Using Php Part1 https://www.youtube.com/watch?v=f85jvD_Y8Ck Check Out This: Top Programming Courses On Udemy http://1bestcsharp.blogspot.com/2016/11/top-udemy-programming-courses.html
Views: 235662 1BestCsharp blog
WEBADI Custom Integrator Creation & Register under Responsibility - Oracle Apps
This video describe to create simple Custom WebADI Integrator and Register under Responsibility Presetup reference https://linuxplsql.blogspot.com/2018/01/register-attach-webadi-function-to.html
Views: 1435 Oracle Apps Hands-On
Blue Prism Video Tutorial | 020 | Object Studio - Part 3 - Using dynamic attributes
In this video you will learn how to use dynamic attributes in application modeller and use the same set of attributes to identify multiple elements by passing the parameters. Now get access to BluePrism environment and materials by signing up on RPA Academy (BluePrism authorized partner) and get a $50 discount by using my discount code BP50. Click the below link to get access. https://courses.therpaacademy.com/course?courseid=blue-prism-developer-course---instant-access---live-training
Views: 45714 Busy Ping
Data Integration Options for Oracle EPBCS, PBCS and FCCS- Part 1
(Our apologies for the audio technical issues.) Would you like to have more options with data integration and automation within Oracle Enterprise Planning and Budgeting Cloud Service (EPBCS), Planning and Budgeting Cloud Service (PBCS) and Financial Consolidation and Close Cloud Service (FCCS)? Watch Deanna Sunde, Oracle ACE, as she explores data integration options for EPBCS, PBCS and FCCS. Part 1 of the 2 part series covers importing and exporting metadata and related use cases (including migrating from on premise), importing and exporting data with jobs (both in Essbase and Planning formats) including exporting text accounts and Smart List values. The discussion also includes exporting data with the DATAEXPORT command in business rule. Attendees of this series will understand how the EPM Cloud tools replace the functionality of on premise dimension build and data load rules, .bat and maxl scripting. Use cases and pros and cons for the methods are discussed as well as the file format requirements, options, and code examples. Example EPM Automate scripts will also be presented.
Views: 982 KeyPerformanceIdeas
Walk-through: Capture Name-Value Pairs Action
Successfully capturing all the data in a name-value pair list has traditionally been a time intensive process. The new Capture Name-Value Pairs action provides a streamlined way to create the necessary Capture actions in just a few seconds.
Views: 685 MozendaSupport
XMLTABLE : Convert XML into Rows and Columns using SQL
This video gives a quick overview of the XMLTABLE functionality, which can be used to convert XML documents in to rows and columns in SQL. For more information see: https://oracle-base.com/articles/misc/xmltable-convert-xml-data-into-rows-and-columns-using-sql https://oracle-base.com/articles/misc/sqlxml-sqlx-generating-xml-content-using-sql Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Mike Hichwa : Twitter : https://twitter.com/mikehichwa1 Cameo appearances are for fun, not an endorsement of the content of this video. All trademarks, product names and logos are the property of their respective owners.
Views: 19149 ORACLE-BASE.com
Loading and Extracting Dimension Members in Oracle Enterprise Performance Reporting Cloud Service
In this tutorial you learn how to load and extract dimension members in Oracle Enterprise Performance Reporting Cloud Service.
Parsing a JSON payload into Entries
This video shows you how to parse out repeating objects that appear in hierarchical data (in this case, a JSON payload) and represent this data as Attributes in an Entry.
Views: 3445 Eddie Hartman
Learn Linq to XML With C# - Part 6:  How to Access XML Elements based on Attribute Value
Subscribe for more lessons More Linq to XML on: http://kindsonthegenius.blogspot.com/2018/02/learn-xml-in-c-using-linq-to-xml-video.html Programming Tutorials: http://kindsonthegenius.blogspot.com This tutorial teaches how to query an xml file and retrieve data based on the value of an attribute
Views: 231 Kindson The Genius
Finding Database Columns By Name in Oracle SQL Developer
How to find all columns in your Oracle Database by searching on the name.
Views: 4824 Jeff Smith
Excel Magic Trick 894: Extract Records Between Two Dates: Filter or Formula
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to : Extract Records Between Two Dates: Filter or Formula: 1. Static Data: Filter using Between Crteria and then copy and paste 2. Data that changes use formula for dynamic results that update instantly. See array formula that uses COUNTIFS, INDEX, SMALL ROWS, ROW and IF Functions. 3. See the the Excel 2007 function: IFERROR 4. See the 2010 Function AGGREGATE 5. See the Excel 2003 function COUNTIF
Views: 106281 ExcelIsFun
SQL: ACID (Transaction properties)
In this tutorial, you'll learn what is ACID PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 2474 radhikaravikumar
jQuery datatables get data from database table
Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/jquery-datatables-get-data-from.html In this video we will discuss how to use database data with jQuery datatables plugin. There are many ways to get data into DataTables. If the data is small you can retrieve all the data at once and the processing (i.e paging, searching, ordering) is done on the client-side. On the other hand if the database data is large, server-side processing can be enabled. With server-side processing enabled, all paging, searching, ordering actions that DataTables performs are handed off to the server. In this video we will discuss retrieving all the data at once. The datatables plugin performs all the processing (i.e paging, searching, ordering etc) on the client-side. We want to retrieve data from the following database table tblEmployee. The database data should then be displayed using jQuery datatables plugin
Views: 132367 kudvenkat
How to Add Column To Existing SQL Server Table with Default Constrain - SQL Server Tutorial
How to Add a Column with Values to Existing SQL Server Table - TSQL Tutorial / SQL Server Tutorial We often have to add a new column to existing Table/s. Let's consider we have dbo.Customer table and we are US based company and we never did business outside USA. so we never need Country Column to our existing Table for Address as we only operator in USA. Now company has decided to expand the business and might have the customers from other countries. What we want to do , we want to add column to existing table with default value. All the existing values should be also updated to default value when we add this new column. Moving forward if no Country Name provided, It should take USA otherwise value provided. blog post link for script http://sqlage.blogspot.com/2015/03/how-to-add-column-with-values-to.html
Views: 22940 TechBrothersIT
Import Metadata Using a Flat File in Oracle Planning and Budgeting Cloud Service (PBCS)
Have you ever have problems with importing metadata into PBCS? There are several ways to solve this problem, but the best way is by creating a flat file. A flat file is a file that contain records with no structured relationships. The records are stored in a simple table with one record per line. The most common type of flat file is the CSV file or comma separated values which can be created in several ways but in this demonstration, we will be using Microsoft Excel to create the file.
Views: 1578 KeyPerformanceIdeas
Priv8 : SQLi using extractvalue()
SQLi using extractvalue
Views: 446 w77s
PL/SQL Tutorial : SYS REFCURSOR Dynamic Cursor Variable
PL/SQL Tutorial : SYS REFCURSOR Dynamic Cursor Variable How to return Multiple values in Function using SYS_REFCURSOR SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 278 TechLake
Apigee Edge - 4MV4D - Drupal Developer Portal - Developer Attributes - S04E07
Find out how to collect developer attributes using Apigee Drupal Developer Portal & Send same to Apigee Edge which can be retrieved during API runtime using policy like Access Entity to take action based on developer attribute. Q & A - Please refer to https://community.apigee.com
Views: 472 apigee
MySQL Database Tutorial - 27 - How to Insert Multiple Rows
Facebook - https://www.facebook.com/TheNewBoston-464114846956315/ GitHub - https://github.com/buckyroberts Google+ - https://plus.google.com/+BuckyRoberts LinkedIn - https://www.linkedin.com/in/buckyroberts reddit - https://www.reddit.com/r/thenewboston/ Support - https://www.patreon.com/thenewboston thenewboston - https://thenewboston.com/ Twitter - https://twitter.com/bucky_roberts
Views: 104036 thenewboston
Blue Prism Video Tutorial | 014 | Collection and Loop Stages
This video walks you through the collection and Loop stages in Blue Prism. Now get access to BluePrism environment and materials by signing up on RPA Academy (BluePrism authorized partner) and get a $50 discount by using my discount code BP50. Click the below link to get access. https://courses.therpaacademy.com/course?courseid=blue-prism-developer-course---instant-access---live-training
Views: 75220 Busy Ping
Adjusting and Spreading Plan Data in Oracle Planning and Budgeting Cloud
This tutorial demonstrates how to spread and adjust data in Oracle Planning and Budgeting Cloud. Learn how to spread data from summary time periods to base time periods. Quickly adjust plan data by a percentage or value. Learn how to use the Grid Spread option to specify an amount or a percentage to increase or decrease values across multiple dimensions. The spread is based on the values in the targeted cells.
Primary Key & Foreign Key Implementation: MySQL
http://technotip.com/2931/primary-key-foreign-key-implementation-mysql/ Implementation of Primary Key and Foreign Key, using MySQL Practical approach and the benefits of using Primary and Foreign key concept in a relational database design.
Views: 217813 Satish B
BluePrism - String Reg Expressions || Reality & Useful
Hi Friends, Now we will discuss about 'Utility - String' Regular expressions -------------------------------------------------------------------------- Why we need to use regular expressions and which scenario we need to use them? -------------------------------------------------------------------------- Let's take an example, I have one data item contains alphabates and I want to check wheather the data item having only alphabates or numbers or alphanumarics or any other condition checks. These type of operations we can do using regular expressions. -------------------------------------------------------------------------- we can find the syntaxs of regular expressions in w3scools. see here few of the regular expressions [abc] the string should contains a, b, c letters combination only [^abc] doesn't contains the combination of a, b, c or individually [0-9] string must contains only digits [^0-9] string should not contain numbers (x|y) Find any of the alternatives specified --------------------------------------------------------------------------- let's try on these expressions using 'Utility - String' regular expressions See we have an Action to use 'Test Regex Match' and it is expecting the inputs Regex Pattern - This is regular expression syntax Target String - This is, on which string we have to match Output will be the Flag type mean, either matching or not, true or false --------------------------------------------------------------------------- 1. Let's check with the number [0-9] pattern My target string should contain only numbers not any other symboles or alphabates. let's check it See I got true, because my target string having only number. If I give alphabates? see the result -- I got the false result What if I give combination of alphabates and numbers or other symboles too? see once Well, we got true. That means it is accepting the other characters along with the numbers. Let's restrict the alphabates in this using [0-9] ^[a-b] we got the false. --------------------------------------------------------- 2. Now we will see about [abc] expression I gave target string with in the abc letters that's why I got true. Let's include other characters. It gave me true and accepting the other letters If we don't want other letters to accept include ^[d-z] Let's try See now we got false. ^ means inverse/not case Now we will avoid the abc letters and use it for [abc] expression Results are false, because Target string doesn't contain abc letters. Make sure to know about the meaning of regular expression first. already we got idea about ^ symbol ^ - not case [] - are used for expression symbol - - used for range(between) like 0 to 9 or between 'a' and 'z' Thank you for watching video
Views: 6450 Reality & Useful
Installing Oracle Database 12c on Linux
Installing Oracle Database 12c on Linux Contact: రవి కుమార్ . లంకె Ravi kumar Lanke Blog: www.installationbyravi.co.in Gmail : [email protected] Yahoo : [email protected]
Views: 385 Ravikumar Lanke
Reviewing Data in Oracle Planning and Budgeting Cloud
This tutorial demonstrates how to review form data in Oracle Planning and Budgeting Cloud. You learn how to view a member formula for an account to see how that value was calculated. You see how you can filter rows and columns to select what data to display on forms. Finally, you also see how you can organize form rows and columns so data is displayed in ascending order, descending order, or in the order of the dimension hierarchy.
New Options in Data Management (Smart Lists & Data) for Hyperion Planning and PBCS
Have you ever been frustrated not being able to load Smart List members using Data Management? Did you have issues with loading HR data because the accounts are in the columns? Watch the demonstration on how to easily resolve these issues. Oracle recently added new functionality in the October update to resolve these issues. Now, you have the capability of loading non-numeric value using data management and loading accounts in the columns. Watch the demo and learn how to load non-numeric data with accounts in the columns?
Views: 1840 KeyPerformanceIdeas
comScore Webinar: Data Monetization - Leveraging Subscriber Data for Rapid Service Development
Monetizing data is an important way for carriers to extract more value from their fast growing data networks. By leveraging next generation analytics platforms, carriers take advantage of a real-time analytic and marketing engine to create highly personalized and time-sensitive offers that uniquely impact customer segments. In this webinar, you will discover solutions that provide rich insights on subscriber behavior such as analyzing respondents across many demographic attributes, locations, device types, and more.
Views: 2217 RCR Wireless News