Scenario We want to create a target flat file name with the current system date. Solution 1 The first method is renaming the target file name in the post session command as bellow: Example: The following command will rename the file in the format filename_MMDDYYYY.out in Windows: move $PMTargetFileDir\filename $PMTargetFileDir\filename_%date:~4,2%%date:~7,2%%date:~10%.out
Data + Intelligence
SSRS – Have you used it yet?
While there are several BI technologies and more coming into the foray every day, SSRS has remained a key player in this area for quite some time now. One of the biggest advantages of SSRS reporting is that it involves the participation of the end user and that is very intuitive to use. Let’s go […]
Facebook Post Types: Picking a Winner Isn’t Easy
It’s no secret that at StoneTemple we are Google+ enthusiasts. It’s widely known in the Google+ community that image posts are the most effective. And it makes sense; today’s users expect a rich experience when they interact with the web, with quality, eye-catching visuals that convey the tone and message of the content. For most […]
The Key to Driving Down Healthcare Costs
Healthcare costs are rising at a faster pace than the economy is growing. Hospitals are often the focus of this concern, because they constitute the largest single component of healthcare spending. When looking at hospital costs, it is important to keep in mind that there are both direct and indirect expenses that contribute to the […]
Realizing Agile Data Management …
Years of work went into building the elusive single version of truth. Despite all the attempts from IT and business, Excel reporting and Access databases were impossible to eliminate. Excel is the number one BI tool in the industry and for the following good reasons : accessibility to the tool, speed and familiarity. Almost all […]
Knowledge Drives Precision
In recent years, dramatic advances in molecular biology, genomics, and related technologies have resulted in greater understanding of cancer at the molecular level. It is now possible not only to identify the genetic and molecular variations in each patient’s cancer cells, but to apply the results from the tumor profile, in some circumstances, to begin […]
Fulfilling Real-Time Analytics on Oracle BI Applications Platform
Fulfilling Real-Time analytics on Oracle BI Applications platform Analytics users have always had the desire to get “real-time” data. There are certain business scenarios where the ability to do real-time analysis can positively impact different areas of our Business – from increased revenue to a greater customer satisfaction. Most of the Oracle BI Application deployments […]
Rounding out Cognos TM1
Currently there are 4 options for rounding numbers in Cognos TM1. They are: Rounding in reports. Rounding during loads. Rounding with the Cube Viewer. Rounding with rules. Rounding in Reports The most popular method to apply rounding in TM1 is in reporting. Cognos TM1 leverages MS Excel for reporting and supports all of the formatting […]
ACA and QRS – Shoot for the Stars Part 3
In ACA and QRS – Shoot for the Stars Part 1, I laid out the overall domains that are going to be used to score QHP plans offered through the Marketplace. In Part 2, I discussed some factors to consider for the data derived measures. In this blog, we will take a closer look at […]
DevOps Considerations for Big Data
Big Data is on everyone’s mind these days. Creating an analytical environment involving Big Data technologies is exciting and complex. New technology, new ways of looking at the data which is otherwise remained dark or not available. The exciting part of implementing the Big Data solution is to make it a production ready solution. Once […]
3 Questions Apple Must Answer to Reduce HealthKit Skepticism
There has been a lot of buzz around Apple’s announcement to enter the healthcare space with the unveiling of their Apple Watch and HealthKit app. HealthKit seems to be gaining momentum due in large part to Apple’s strategic partnerships with healthcare industry heavy-hitters. However, many questions remain unanswered and Apple must address them to gain […]
Virtualization – THE WHY?
The speed in which we receive information from multiple devices and the ever-changing customer interactions providing new ways of customer experience, creates DATA! Any company that knows how to harness the data and produce actionable information is going to make a big difference to their bottom line. So Why Virtualization? The simple answer is […]