Category: Database

BusinessObjects Universe Design Tool: Each calculated column must have an explicit name

BusinessObjects Universe Design Tool: Each calculated column must have an explicit name

In SAP BusinessObjects Universe Design Tool, you might get the following error – “Each calculated column must have an explicit name”. Even though the query runs fine in the underlying database, but Universe Design Tool doesn’t accept it. The reason is it expects ‘AS’ keyword between the calculated column and its alias. So that query…

Read More Read More

Run MySql without installation

Run MySql without installation

Note: This applies to MySql version 5.7. See the comments section of this post for version 8.0. I have been looking for a portable version MySql database which I can just copy on my machine and start using with installation. It took a little bit of effort to make it work. Here are the steps…

Read More Read More