We Have a Blog

Business Objects Licensing

Types of licenses

There are 2 ways that we license content viewing in the BI platform:

  • Named Users
  • CSBLs – Concurrent Session Based License

Business Objects Sizing Guide 4.1

References

http://scn.sap.com/community/bi-platform/blog/2013/01/30/bi-platform-licensing-basics-csbls-and-named-users

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/50770d8f-5606-3010-28a6-9e3bb14ec6a7?QuickLink=index&overridelayout=true&59064390299973

Web Intelligence Calendar Year/Month Issue

In this reports the client is experiencing an issue in Web Intelligence where the Calendar Year/Month shows up in the following format “200,702”

Here’s an example below from Web Intelligence

 

You can test out the Calendar Year/Month by creating a variable “TestCalendarYear”using the IsNumber function

 

This proves we are working with a number; you could also use the following

  • IsDate()
  • IsString()
  • IsLogical()

So now we will have to convert this number to a date, first we will format the number by using FormatNumber() Function

FormatNumber([Calendar Year/Month];”#######”)

Next convert the number to date by using the ToDate() Function

ToDate(FormatNumber([Calendar Year/Month];”#######”); “yyyyMM”)

And then Format the date in the proper format using FormatDate() Function

=FormatDate(ToDate(FormatNumber([Calendar Year/Month];”#######”); “yyyyMM”); “Mmm yyyy”)

 

Here’s what then end result variable looks like

 

 

And the output in Web Intelligence

 

The result we were looking for.

If you have any questions feel free to contact me at info@vynesolutions.com

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Creating a Universe with the Information Design Tool

Information Design Tool

The Information Design Tool (IDT) is the new tool in the Business Objects 4.0 toolset that is used to build universes. In the Business Objects 3.1 suite the tool used to design universes was the universe design tool. The universe design tool does come with the Business Objects 4.0 package but it is basically used for .unv universes(old) . The Information Design Tool creates universes that have a .unx ending.

In order to create a universe with the Information Design Tool (IDT) you have to do the following:

  1. Create a Project
  2. Create a Connection
  3. Create a Data foundation
  4. Create a Business layer
  5. Last part is to publish the Universe so Web Intelligence, Crystal Reports and other tools can utilize the universe.

Now let’s dive deeper into each area

First we have to launch the Information Design Tool, go to ‘Start Menu’ ->’SAP Business Intelligence’ – >’SAP Business Objects BI Platform 4 Client Tools’


read more…