We will get the error like "=com.orangescape.hce.customformula.getObjectIndex()" in almost all the formula fields like objectindex(),currentuser()...
The above error occur when we copy or move the studio from one location to another.For eg from drive c: to d: or when JAVA_HOME has been set to jre instead to jdk
Set JAVA_HOME pointing to JDK
Added by Santhosh Mahizhan on March 30, 2009 at 6:08pm —
In Database configuration Screen we need to select MSSQL.
Use the following values for url and driver .
For URL : jdbc:sqlserver://localhost:1433;DatabaseName=dimension;currentSchema=dbo;
For Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
Rest of the steps are same as you do for normal installation.
Note : You can use the existing driver support MS SQL 2005
Added by Santhosh Mahizhan on March 30, 2009 at 6:07pm —
Inbox preference is not displayed in the preference page.
Root template name different from model name.
• Download the editPreferences.jsp file from the following link http://groups.google.com/group/orangescape/files
and extract the zip file
• Replace the extracted file in the following path DimensionStudio\eclipse\plugins\com.orangescape.dimension… Continue
Added by Santhosh Ponnusamy on March 30, 2009 at 2:20pm —
While you were using Special characters "ö"
like this in a public cell as a text field, it will get saved and also will get deployed from DimensioN Studio without any error. When it was Instantiated and saved in the portlet, then you will not be able to view your inbox. The following is the message that will be get displayed in the inbox.
" XML Parsing Error: An invalid character was found in text… Continue
Added by Santhosh Ponnusamy on March 20, 2009 at 3:00pm —
You can use of the NOLOCK option in select statement allows you to get a result set without having to deal with the locking and blocking issues. ex. SELECT * FROM testTable with (nolock) Go through below url for more information. Remove some SQL Server blocking issues with the NOLOCK hint http://www.mssqltips.com/tip.asp?tip=1232 Executing SELECT statements in SQL Server without locking processes http://www.mssqltips.com/tip.asp?tip=1646
Added by Inder on March 20, 2009 at 2:28pm —
Sometimes we would like to reuse a report for another report where we need to do minimal changes.In such cases we may copy,paste and rename it. Instead we can use the option "Register template for new report".
In report design view go to navigator right click on the report you want to reuse, you can see an option at the last saying "Register Template with New report wizard".Once you click on this a small window will pop up and ask you for display name, give a relevant name also give… Continue
Added by Jothi on March 4, 2009 at 6:08pm —
In DimensioN 2.4 we can make use of a model instead of report parameter pop up to get parameters.
If we use Model to get parameter we can validate the values provided by the user.For e.g. we can check for invalid date range.
These are the steps you need to follow to implement that :
1. Create a model with fields similar to report parameter fields for a report and deploy it.
2. Go to report preferences in the browser you can see two options in report… Continue
Added by Jothi on March 4, 2009 at 5:49pm —
Installation of DimensioN server for SQL Server 2005 is not the same as you do for other databases
In Database configuration Screen we need to select MSSQL not MSSQL 2005 .Use the following values for url and driver .
For Enter URL
For Enter Driver
Rest of the steps are same as you do for normal… Continue
Added by Jothi on March 4, 2009 at 12:00pm —
While you are using Internet Explorer 8.X versions, by default you will not be able to work in Custom Editor.From IE8 if you make click on Custom Editor from edit preferences, a blank window will pop up as below and the controls such as Text boxes or Labels will not be get displayed.
In order to avoid this issue, we need to do the following steps:
(1) If you need the current page alone must be compatible for view, just… Continue
Added by Santhosh Ponnusamy on March 2, 2009 at 7:05pm —