One of the nice features of SAP Data Integrator that DTS just cannot compete with is how it deals with datastores at run time. For an overview let's think about how the process will normally work…Read more
So, recently I find myself heavily involved with SAP Data Services and data migrations, I know what you’re thinking … that's not real code! And you’re damn straight …. it isn’t, but I have always leaned heavily towards the data end of the spectrum rather than the UX end which is filled with sorcery, witch craft and more importantly users who are like little pixies with no respect for the sanctity of code; data is data though and it doesn’t press buttons marked ‘Nuclear Button, Do Not Press’ just for kicks. I thus don’t complain too much (ahem) when ETL jobs come my way. One of the biggest challenges with ETL in the SAP world is to keep everything down at the database level, it’s very easy to slip up and watch your execution times rattle up to unusable very quickly all because you used a feature for which there is no direct database equivalent and at times it is frustrating at how the simplest functions are not covered; bygones.Read more
If you use a month name field (or convert a month number to name), it is a string object, so orders alphabetically in a report. The report users can change this with a custom sort but this is cumbersome.Read more
I've just taken a look at the new Waterfall Chart feature in CR4E 4.2 SP2. I thought the idea of tracking weight loss over a period of time would be a good visual representation of the data. My data is very simple, consisting of a weekly period starting on the first Sunday of the week from the beginning of 2016 until the current week. I have stored the weight in kilograms and then a variance from comparing the weight loss (or gain!!!) between weeks.Read more
If you are running SAP BusinessObjects Enterprise or Edge 4.0 or SAP Crystal Server 2011 this article will explain the additional capabilities available to your organisation by moving on to version 4.2/2016.Read more
SAP BusinessObjects Design Studio enables application designers to create analysis applications and dashboards – based on universe data sources – for browsers and mobile devices (iPads, for example).
The other reason we like it is that it is totally customisable but requires application development skills to carry out this customisation and this is what we do very well at The Business Objects People.Read more
Our Support Team at DSCallards is regularly asked how to move the SAP BusinessObjects BI Platform 4.1 Central Management System (CMS) database and Auditing database.
The Central Management System (CMS) database is the database that sits behind the SAP BusinessObjects BI Platform 4.1 application. It has information about users, groups, Filestore locations of Business Intelligence content stored within the application, and plays a critical part of the platform.
The Audit database stores usage and activity related to the SAP BusinessObjects BI Platform 4.1 system, with information such as who logs on, who runs what reports and when and more.
I thought I would share the steps I took to do this.Read more
An Instructive Tale About the Installation of SAP Sybase IQ
The aim of this blog is to share the story of the installation of a complex software application and the steps taken to troubleshoot issues when they arise.
Overview: The implementation of a fast database is an essential part of everyday life for an organisation with diverse Business Intelligence and Analytics requirements, particularly in the realm of ‘train-of-thought’ querying.
According to International Data Group, “Unstructured data is growing at a rate of 62 percent per year. When coupled with increased use of analytics, companies are finding new ways to maximize insights for things such as employee hiring and engagement, customer experience and product development and delivery. In fact, organizations want to find cheaper, faster and better ways for those insights to be delivered where they’re needed most. That means that organizations need to focus on how to effectively manage and store data in a smart way.”
This journal will show the steps taken when installing the product and methods of troubleshooting when things don’t turn out quite as planned.
Click here.Read more
The Business Objects People are a specialist SAP BusinessObjects consultancy firm. We provide a low risk, low commitment option to your SAP Business Objects resourcing needs.
Our consultants have an average of twelve years’ experience working with SAP BusinessObjects/SAP Crystal software and we are an accredited SAP Partner Centre of Excellence for Business Objects. Our staff are certified in their expertise of SAP Business Objects and the processes by which we support it.Read more
The team with the best car often but not always win the Formula 1 Grand Prix. Why is this? The skill and experience of driver, engineers and team management all have a part to play in defining the race strategy, delivering the race strategy and tactically adapting to changing circumstances throughout the race.
Similarly simply possessing the market-leading business intelligence software, in SAP BusinessObjects, does not guarantee an answer to a business question. Such that an organisation can have a wealth of data sources without being able to find the relevant data.Read more
If you first implemented SAP Business Objects before 2013 you probably have universe(s) built with Designer, one of the all-time classic software tools.
The SAP Business Objects universe, with its accompanying imaginatively-named design tool, was the first software designed to turn data into information; by turning ‘data objects’ into ‘business objects’Read more
It lets you model your business data into information that makes sense to humans who need to make good decisions. It makes a little knowledge a powerful rather than dangerous thing by quietly translating your human question into an unambiguous data query that a data machine can respond to accurately.Read more
In the last week, have you made journeys with a switched on mobile phone, posted, liked or uploaded a photo on Facebook? Have you searched the internet? Watched videos on Youtube?
Then you are data, a small part of big data in fact.
Does your company have a website? Does it do any marketing or sales?
Then it’s generating big data, the hundreds or thousands of data points that define any one journey through a website quickly accumulate.Read more
DSCallards has been delivering value-driven Business Intelligence (BI) for over ten years to hundreds of customers and understands the main pitfalls when implementing a new solution.
So, if you are thinking about investing in a new BI solution, we would recommend that you consider the following six points when selecting your solution partner. Each of our recommendations is backed up with a customer case study, which you may find an interesting read!Read more