WIS 10901: ORA-01830 date format picture ends before converting entire input string

ORA-01830 date format picture ends before converting entire input string. (WIS 10901) Scenarios when I could expect this error: Convert Date field to other format. Example I want to calculate a filter for rolling 12 months. TBL_DIMN_CALN_POST.D_PERD is my date field...

WIS 30567: Error occurred while attempting to reconnect to CMS : Not a valid logon token. (FWB 00003)

Could not save the document to the repository for the following reason: [repo_proxy 30] DocumentFacade::uploadBlob - Query execute has failed : Error occurred while attempting to reconnect to CMS : Not a valid logon token. (FWB 00003) (hr=#0x80042a70) (WIS 30567) Scenarios...

Practical usage of SELF operator in Web Intelligence

Let’s check some scenarios where we can use SELF operator with Previous function. Example 1. If we want to populate a specific sequence or series We require to start with 3 and continue the series with multiples of 3. =3 + Previous(Self) We can use any calculation...

When to use Database Ranking in Web Intelligence Report

We will discuss what is Database Ranking and how and when we can use it in Web Intelligence Report. We will also compare its advantages over report level ranking....

SAP Business Intelligence and Analytic Market Share Trend

While working as an SAP BusinessObjects developer, sometimes it strikes me to think – how the SAP BI is working in current market and what is the future scope of this tool. I know that for the enterprise environment, where I am working, it is a perfect fit for my customer requirements....

Trick | How to show Pyramid chart in Web Intelligence Reports (SAP BusinessObjects)

How beautiful it looks like if we add these Pyramid charts in Web Intelligence reporting and get a response “WOW!!!”. Let’s check how we can make the webi report more colorful and livel...

Which certification for Data Warehousing/Business Intelligence is worth and most widely accepted?

Data warehousing is an emerging field with great potential of further growth. Scope and penetration of its usage is tremendous. Almost every business domain is using and implementing business intelligence in one way or other. With increasing rate of BI deployments, Business intelligence...