MDX (Multi-Dimensional query Expression Language) is the data manipulation language for Essbase which is used to convert the BSO outline Calculation scripts to ASO outline calculation. Aggregate outline performs calculations dynamically and can be compared with the BSO dynamic formulas. MDX language is supported by ASO and BSO but the Calc language is specific to BSO.
Differences between ASO and BSO
When to use MDX??
Scenario 1: Converting Q-T-D BSO Functions
Solution: Create a new member “QTD” under dimension which is tagged as “Time”. Add sibling members as shown below
Scenario 2: Converting Time Balance Functionality
Solution: Time Dimension member hierarchy should be defined as “Stored” to use the time balance functionality. If the member hierarchy is not “Stored” then create a formula member as shown below
WITH MEMBER [Measures].[Starting Inventory] AS
([Measures].[Opening Inventory], OpeningPeriod ([Year].Levels(0),[Year].CurrentMember)))’
The purpose of the function is to return the first sibling among the descendants of a member at a specified level. All function parameters are optional. If no member is specified, the default is [Time].CURRENTMEMBER. If no level is specified, it is the level below that of member that will be assumed.
To know more about opening period refer
Mark Polly, Director at Perficient, is packing his bags to head out to the renamed Digital Experience Conference next week.
In the past this conference has been called “Exceptional Web Experience” and “Portal” conference and the new name reflects not only the market changes taking place, but also IBM’s approach to the market. The market is no longer a “Portal” market or even just a “Web” market.
I think that “Digital” explains that we are focused on more than just the web. We have to be just as concerned with other channels, such as mobile, kiosk, TV, game console, etc). And “Experience” broadens the scope to include customer experience, employee experience, patient experience, member experience, and so on. So Digital Experience is a good name for this conference.
In this latest blog post, Mark talks about what you can expect from IBM at the conference as well a wrap-up of the multiple sessions that Perficient will be presenting at the conference next week. You can read all of the details here and you can follow us during the conference on Twitter.
Decision management is increasingly becoming an important facet of Business Process Automation. This means that building decision models as a way to specify the requirements is more critical in business rules projects. The Object Management Group Board of Directors voted to publish the Decision Model and Notation (DMN) as a specification earlier this year. It provides a graphical notation to accurately describe decisions by both business analysts and technical users in process models.
Another goal of DMN is to provide a standard for execution similar to Business Process Management Notation’s Web Service Business Process Execution (WSBPEL) and interchange of business rules. This article will focus on the graphical notation of DMN.
The Necessity for Decision Modeling Notation
The DMN standard is designed to work alongside the Business Process Model and Notation (BPMN), providing the mechanism to identify and describe business decisions within the process model. While BPMN is great for process modeling, it does not provide an easy ability to capture decision requirements in a BPMN diagram. Capturing decision requirements in the process model makes them complex and difficult to maintain.
The Value of Decision Modeling Notation
The DMN value proposition to business process improvement software and business rules projects are the following:
The Impact of Decision Modeling Notation
Software will be required to match applicable compliance or conformance points in order to claim compliance to the DMN’s standards. There will be several levels of Decision Model Notation compliance, however, since this information is still being published, it will not be covered within this article. Decision discovery tools based on the Decision Modeling Notation graphical notation has already been released from IBM.
The latest release of IBM’s cloud-based IBM Blueworks Live is ideal for capturing and managing decision models as part of the process analysis in a collaborative environment. Users can take advantage of the tool to identify, understand, and document key business decisions within the organization. This will allow them to acquire knowledge necessary to determine what is driving key business operations. The features of IBM Blueworks Live in decision discovery are a topic of future articles. The application does not have the capability to import and export decision models which limits it to decision discovery.
The Satisfaction of Decision Modeling Notation
Decision Model and Notation provides a common language and bridges the gap across business, IT, and analytic departments within organizations. The result is better attention paid to modeling decisions in processes. This brings the opportunity to improve collaboration, increase re-use, and easily implement accurate decision management solutions, resulting in lower cost and improved time to market for business rule projects. Organizations can also achieve cost reduction by standardizing skill sets, common notation for easier training and use, and reducing support for business rule management initiatives. The end results in a more agile business with complete, accurate decision making.
There are two common scenarios in IBM BPM Process designer while integrating with Web Services. It can be either inbound or outbound integration.
Outbound Integration involves the Business Process Definitions (BPD) invoking external Web Services as part of the process. It is a straight forward configuration – Giving WSDL url in web service integration activity embedded in Integration Service component.
This document focuses on inbound integration and involves exposing the BPD as a web service for external users. For Process Manager to kick off a service, you need to build several IBM BPM components and corresponding services.
Below is the diagrammatic representation of interaction between different components in inbound integration.
Below is the sample BPD that need to be exposed as a WebService
An Inbound integration configured to kickoff BPD has the following components
1. Web Service – It is created for an external system or application to call into Business Process Manager
2. Integration Service – A service with appropriate inputs is created to call the undercover agent (UCA) to send the event
3. Message Event
4. UCA – (Under Cover Agent) The UCA tells IBM® Business Process Manager what service to run when the message event is received
5. General Service – The UCA that you attach to the message event needs a service to pass the parameter values from the runtime message to the BPD
Create a new Web service implementation as shown below.
In the Operations section, press Add for each operation that is desired to be exposed on the WebService. For each operation added, an IBPM Service needs to be associated with it. This implies that the service must be created before adding the operation. When deployed, a call to a named operation will result in the invocation of the corresponding IBPM Service. Any parameters defined as input on the IBPM Service will be exposed as parameters on the Web Service call. Any parameters defined as output on the IBPM Service will be returned as parameters on the Web Service call.
WSDL URI in the behaviour section is the Web URL that can be used to retrieve the WSDL file that describes the exposed Web Service.
A Web Service definition created above need to be associated with a Integration Service. It is this Integration Service that will be called when the Web Service is invoked. This Service should cause the invocation of the UCA. A suitable Service may be designed as below:
The UCA tells IBM® Business Process Manager what service to run when the message event is received. The message can be triggered by IBM BPM itself or by an external system as in this example.
Associated with a Message Start Event node is a UCA. A UCA acts as the “trigger” to the Start Message Event. Before we can define a UCA, we need a General Service that is to be associated with the UCA. The result (output) of the General Service is the “value” passed by the UCA to its associated partner which in this case will be the Start Message Event Node in the BPD.
A suitable General Service may just pass the input to the output
Now that the UCA is available, you can attach it to the message event in BPD.
When an event occurs, that event must be matched against the correct instance of the process for which the event is destined. The ability to match the event against the correct instance is called correlation. You must specify one variable in the message event that has a value that matches the value of the incoming event’s UCA payload (the correlation value). If there is such a match, the message is received. If not, the message is not received, and the event continues to wait.
As all the components are configured and ready for testing , we can employ any web service testing tools like soapUI to send a request to the BPD and could see the tasks getting initiated in process portal.
Recent studies indicate more than 90% of the world’s data was created in the last 2 years, and the cost of maintaining that data is increasingly becoming a liability for IT, Legal and Business groups. As the amount of structured and unstructured data dramatically expands, the expense of maintaining data stores is outpacing the reduction in storage costs.
To help your organization address the issues associated with growing data capacity requirements, IBM offers StoredIQ, a leading unstructured data management and intelligent eDiscovery solution. Join us for an upcoming webinar on July 9, 2014, Transform Unstructured Data into Relevant Data with IBM StoredIQ, where our experts will cover:
Our speakers Sibito Morley, worldwide Director of Information Lifecycle Governance at IBM, and Christine Livingston, Perficient’s Advanced Case Management practice leader, will discuss how to most effectively deploy IBM StoredIQ in order to:
To register for the webinar, click here.
Transform Unstructured Data into Relevant Data with IBM StoredIQ
Wednesday, July 9, 2014
10:00 am CT
Jim Miller, Senior Solutions Architect at Perficient, recently wrote a blog post about sessions, calculations and filters in Framework Manager:
In Framework Manager, an expression is any combination of operators, constants, functions, and other components that evaluates to a single value. You can build expressions to create calculation and filter definitions. Acalculation is an expression that you use to create a new value from existing values contained within a data item. A filter is an expression that you use to retrieve a specific subset of records.
In his blog post, Jim goes into great detail on how to use IBM Framework Manager to perform your calculations. You can read his full blog post here.
We have just signed our silver sponsorship agreement to this year’s IBM Digital Experience conference coming up in July and I found this great blog from Brendon Jones with an IBM video on digital disruption and the importance of building digital into your business model.
The video explains the 4 transforming principles for new digital business models:
I have also reviewed the preliminary session directory for this year’s event and am impressed with the line up of clients, IBM experts, and of course Business Partners presenting. Perficient has 4 sessions including a joint session with our client Florida Blue, where we will show how they continue to engage consumers using the portal platform with content management, analytics, personalization and social interaction to deliver multichannel exceptional customer experiences with measurable ROI.
Check out Brendon’s blog post and video here.
And don’t forget to register for the IBM Digital Experience Conference.
IBM announced yesterday a new all-in-one packaged offering to enhance their current cloud based solutions for the enterprise. This is in addition to their existing cloud-based solutions such as IBM SmartCloud for Social Business. Here is a snippet from the announcement
Called IBM Cloud Business Solutions, the portfolio includes multiple components packaged into a single client agreement and delivered “as a service” for speed and simplicity. This includes consulting services, pre-built assets from IBM Research, software, advanced analytics, ongoing support and cloud infrastructure delivered via Softlayer, an IBM company. Pricing is based on a subscription model. Clients pay a set-up fee up front, and then ongoing subscription or usage-based fees.
What is interesting to me here is that this is a “packaged” solution – which includes consulting services to customize the solution based on the needs of the individual customer, analytics driven industry research assets, and industry-specific version for each solution. It is a pay as you use model (with an up-front set up fee) which could considerably reduce the trial costs and help drive adoption. I’d be curious to dig a little deeper into this over the next weeks.
You can find the current list of customizable solutions offered here. A few solutions highlighted in the press release include:
- Care Coordination – With a goal of improving patient outcomes while reducing healthcare costs, this solution enables different stakeholders in a healthcare ecosystem to collaborate across the continuum of care. It integrates the capabilities of care coordination, management, analytics and patient engagement.
- Customer Data – To help clients gain insights and apply them rapidly to business processes, this solution brings together disparate, internal and external data sources to improve marketing operations and planning performance across all channels. By leveraging analytics, clients maximize marketing return on investment.
- Mobile – Mobile initiatives increasingly span enterprises and spur business transformation. This suite of solutions for industries such as banking, retail, healthcare, insurance and travel and transportation provides clients the assets and agility needed to re-imagine and define mobile engagement models with employees, customers and partners. It includes mobile accelerators, mobile designs and development models that support an agile, iterative development process.
- Predictive Maintenance – A lack of visibility into equipment health and inability to accurately forecast downtime results in expensive, unscheduled maintenance. The Predictive Maintenance solution enables a proactive analysis process using equipment and application data to plan, monitor, manage and mitigate equipment failures.
- Smarter Asset Management - Asset management is critical to business operations, but not an area in which business leaders want to invest significant capital. Smarter Asset Management provides clients with minimal resources and low capital investment, optimized for maximum performance.
I came across this blog post from Andrew White, a Research analyst at Gartner controversially titled BI’s days are numbered – Here comes BPM again. The core message of the post is this that BI and data analytics are a means to an end – and it is the change in processes (effected through BPM) that will result in impact on the business.
The insight gleaned from information about customers, markets, and trends and intentions is a good thing, but actually taking action and doing something about that insight, and impacting the actual outcome, is the real deal. Thus BI is being seen for what it is – a means to an end, not the end itself. CIO’s need to wise up, I think, and lessen their focus on BI in isolation, and talk more about how business processes need to become more intelligent.
In my opinion , the emphasis around BI and big data analytics is well deserved. While BPM has been around for a while – the impact of big data (and I use that term loosely) on gathering intelligence consumer behavior is still in its infancy. Just a few years ago – enterprises did not know or in many cases did not care about this data. Even today, most enterprises are not gathering any sort of consumer intelligence data, and the few that are … are still trying to figure our how to make sense of the data. A recent survey by VoltDB concludes that Big Data goes to waste in most organizations. The same data is presented graphically here. So, yes – the “”extra” focus on BI in these current times is well deserved and probably even necessary.
That said, I completely agree that BI is truly a means to an end. Perhaps, in about 5 years time – if big data analytics and BI in enterprises mature enough to enable companies to interpret the data gathered and translate them into actionable process changes – the role of BPM in implementing those changes is unquestionable.
It has been almost a month since IBM announced the release of Digital Experience 8.5 and I just read a blog post from one of our Senior Solution Architects, Shyam Sunter who gives a great tutorial and highlights as he installs the new WebSphere Portal V8.5 Extended Addition.
Downloading the InstallablesIBM made it easy for me to search for WebSphere Portal v8.5 installables and find all relevant e-Assemblies. The only thing that I find slightly irritating is that the relevant WebSphere Portal v8.5 e-Assembly was right at the bottom of the page. No worries – a quick browser text search for got me to the right e-Assembly.Expanding the eAssembly – you can immediately see that IBM has change the packaging a little bit. The e-Assembly only has WebSphere Portal images.In the past, you would have to wade down through a whole list of other supporting software components (TDS, DB2, etc.). This has confused users (both new and old) in the past. No longer the case this time. The right step towards a simpler “Digital Experience” perhaps? Excellent!