How to Make Cube Structure

How to Make Cube Structure Steps for creating Cube Structure on new Data Base: 1. Right click on data source with cube you want to Process (Structure). 2. Script Database as > Create To > New Query . 3. Change “ID” and “Name” to different from original: Example 4. Click “Execute” or press “F5” (Note: It can take some time). 5. Refresh Databases. 6. Open new Database > Right click on the cube you want to process > Process. 7. Choose Process Structure > OK. 8. Right Click on the Cube > Back Up > Save.

How to Replace Necto Server and Necto Databases on SQL Server

1.  Backup the PanoramaAdminDB & PanoramaAuditDB from the original server by: -Open SQL Server Management Studio and connect to the original SQL Server -Right click on the Database -In the menu choose Task –> Backup -In the backup window on the bottom click ‘Add’ and add a wanted Backup destination -Enter file name (include the ‘.bak.’ in the end of the file name) and click OK twice\ 2.  Backup the ‘files’ directory located in \\e-bi\Administration Service 3.  Install Necto on the destination server 4.  Copy all of the above to the destination server (two Databases and ‘files’ folder), put them…

How to Replace Databases on SQL Server

1.  Backup the PanoramaAdminDB & PanoramaAuditDB from the original server by: -Open SQL Server Management Studio and connect to the original SQL Server -Right click on the Database -In the menu choose Task –> Backup -In the backup window on the bottom click ‘Add’ and add a wanted Backup destination -Enter file name (include the ‘.bak.’ in the end of the file name) and click OK twice 2.  Stop Necto services 3.  Delete the PanoramaAdminDB & PanoramaAuditDB on the destination server SQL server by: -Open SQL Server Management Studio and connect to the destination SQL Server -Right click on the…

Hot to Change Default Currency Sign in the Ribbon

Hot to Change Default Currency Sign in Ribbon   Go to C:\Program Files (x86)\Panorama\E-BI\Flash\config and rdit ribbon_defs.xml file. (Before editing we recommend to back up) To make this work for member (members tab under “View tools” section in ribbon). Find this text and change to currency you want by default :         <RItem Type="hbox" Hid="RBN_HB_MEMBER_FRMT_BUTTONS">           <RItem Type="img_button" Hid="RBN_MEASURES_FORMAT_CURRENCY" Value="€##.00"     Tip="Currency" Img="ribbon_mf_currency" />           <RItem Type="img_button" Hid="RBN_MEASURES_FORMAT_PERCENTS" Value="Percent"      Tip="Percent"  Img="ribbon_mf_percents" />           <RItem Type="img_button" Hid="RBN_MEASURES_FORMAT_INT"      Value="#,#"          Tip="Integer"  Img="ribbon_mf_int"/>           <RItem Type="img_button" Hid="RBN_MEASURES_FORMAT_KMB"      Value="0.00 K, M, B" Tip="K,M,B"    Img="ribbon_mf_kmb"/>         </RItem>   To change Image: Image can be changed as adding…

Administration Section in Control Panel

In this article we will go over sub sections in Administration Section in Control Panel. 1. License > Information In this sub section you have information about the product and customer information You can see: Product and Version. What add-on you have (True) and what you don’t have (False). License expire date, number of users and etc.

Send Users from the Application to a Documentation / Data Dictionary

There are cases where you would like to send your users from the BI application to a documentation or a data dictionary explaining the data. How to implement: Go to the component from which the document will be opened. Go to properties of the above component. Actions. JavaScript actions. The syntax should be the following: window.open(‘file://server/folder/file.TYPE_OF_FILE‘); For instance: window.open(‘file://Yes/presentations/MyFile.XSLX‘);

Using Default Member from the Cube

In many cases , there is a need to slice the dashboard or the report on a default member. For instance – You’d like your Sales dashboard to be sliced on “last day” by default, and the end users will have the option to change this slicing for further exploration. The above use case can be implemented for all users, and there is an option to implement that per role, meaning every role (group of users) will have their own default member/s. The steps to implement this use case: 1. In SSAS- create a default member per role / user…