How to find the Necto Version

From time to time you will be requested to provide the exact Necto version that is running/deployed in the organization. Here are two ways to find it and report: 1. Open the Necto Home Page, click the ‘Help’ and choose the ‘About’ in the menu. The exact version is – 16.3.0.0.349 2. If you are unable to login to the UI, we can gather this information from the file version. – Browse to \Common Files\Panorama\ on the Necto server and look for the ‘pnadmin.dll’ file version.

Export and Import Workboards based on the Private Folder

Export and Import Workboards based on the Private Folder (All actions below should be done on the Necto server) Export Workboards from the Private folder On Necto server, go to the following folder: C:\Program Files (x86)\Panorama\E-BI\Flash\Config Open fcommon.txt file Add the following into the file: s450=INI,BI,NAS,NAV,ASP,JS,ALV,GIS3,TB,API Open Necto In Necto, click on the “Help” icon and then on the “About” Click on the “Debug” button and then on “Start Logger” button (make sure the button indicates “Start Logger”) Open another window and copy and paste the following URL: The highlighted in yellow should be the name of your server.…

Export and Import Workboards in the Public Folder

Export Public Workboards 1. From Necto home page, click on the “Management” icon 2. Select the “Workboards” category in the ribbon 3. In the left pane, click on the triangle to display the Public Workboards menu: 4. Select the “Export” option. 5. In the “Export Workboards” window select all Folders/Workboards that you want to export. 6. Click the “Prepare Workboards Content” 7. Now hit the “Save” button and select a location on the disk. Import Public workboards into Necto 1. From Necto home page, click on the “Management” icon 2. Select the “Workboards” category in the ribbon 3. In the…

Environment Maintenance (Server side)

Environment Maintenance (Server side) Please follow the steps to perform an overview of Necto Server and Necto DB Server Related 1. Run the Necto Health Tool. If you don’t have one, you can request from 2. Make Sure you are running the latest Necto version: 3. Verify  you have atleast 10 GB free on the disk where Necto is installed. 4. Check that Debugs are set on “0”: In regedit.exe go to HKEY_LOCAL_MACHINE – >  Wow6432Node – > Panorama – >  Necto – > Admin Debugs to check – > DebugNewAdmin ; DebugServer ; DebugDelivery 5. Clean logs in…

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…