Archive for April, 2012

SQL Server 2005 : Create Database

  • Select Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio
  • Connect to Server using Windows Authentication

  • Connect to Server using Windows Authentication

  • Right-click on Databases. Select New Database…

  • Type Database name. Click OK.
  • The database will be created successfully.

Advertisements

Logon to Essbase Using Essbase MaxL Shell

We can logon to Essbase using various ways. One of them is using Maxl script. This way used because we want to export linked reporting object data. To logon to essbase, follow these steps:

  • Open command prompt
  • Type essmsh and enter. We will jump into MaxL Shell.

Image

  • Before we logon to essbase and we try to query export database, the error will prompt.

Image

  • To fix it, logon to essbase using script :

MAXL > login <HSS user> <HSS Password> on <server name>;

For Example :

MAXL > login admin password on localhost;

Image

  • We already logged in to Essbase.

Linked Reporting Objects

If you are upgrading from an earlier release and an application has more than 127 linked reporting objects, perform the following procedure to export linked reporting objects before you run the Staging Tool.

Tip:  To determine how many linked reporting objects an application has, use the MAXL command query database DBS-NAME list lro all;,

for example, MAXL> query database sample.basic list lro all;

Image