Total Pageviews

Sunday, July 30, 2023

10 Essential Sales KPIs to Track in Your Sales Dashboard

 By putting information together to tell the right story through eye-catching visualisations can be time-consuming if you don’t have an automated dashboard tool. The faster you can turn your data into insights, the better.


That leads to your salespeople working extra hours to create daily, weekly, or monthly Excel reports that are overcrowded with information, are hard to read, and get lost in people’s email. That’s senseless, especially when there’s a faster and more efficient way to access and digest your CRM info.

Sales KPI dashboards are a way to create automated visualisations of your most important sales data and get automated notifications with actionable alerts or snapshots of your business performance. Here’s what to measure and how to do it.

What is a sales KPI dashboard?

Sales KPI dashboards are interactive data visualisations that allow you to have at-a-glance access to real-time CRM data. Dashboards use graphics and visual assets to tell the story of your business, and in this case, of your sales performance.

10 most important metrics for your sales performance dashboard

KPIs are meant to be tracked in order to achieve sales goals in a time period. There are several different metrics that you could be tracking as a sales leader. We’ve compiled a list of the ten we see Trevor.io users keep track of the most:

1. Sales target and growth

Tracking these two together allows you to keep track of your sales against the target and see the growth over a time period. You can add this metric to your sales dashboard by using a BI dashboard feature like dynamic text boxes, or creating automated sales reports with graphics that measure sales vs target.

These metrics also answer the following questions:
  • Is your current revenue higher or lower than your forecast?
  • Is the trend going up or down?
  • How many new customers do you need to meet the target?
  • Is your growth steady? Do you need to double down on a specific period?

Code of Items hide/visible by Push Button in Oracle Forms

Trigger of Push Button WHEN-BUTTON-PRESSED and WHEN-WINDOW-ACTIVATED at form level.

declare

m_label varchar2(30);

begin

m_label:=Get_Item_Property('control.filter' ,label);

if m_label = '- Filter' then

set_item_property('control.state',visible,property_false);

set_item_property('control.city',visible,property_false);

set_item_property('control.from_date',visible,property_false);

set_item_property('control.to_date',visible,property_false);

set_item_property('control.filter',label,'+ Filter');

else

set_item_property('control.state',visible,property_true);

set_item_property('control.city',visible,property_true);

set_item_property('control.from_date',visible,property_true);

set_item_property('control.to_date',visible,property_true);

set_item_property('control.filter',label,'- Filter');

end if;

end; 

Tuesday, July 4, 2023

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

ORA-12528: TNS:listener: all appropriate instances are blocking new connections OR

ORA-12528 message 12528 not found product=rdbms facility=ora

Tried to connect a NOMOUNT database, but it failed with ORA-12528.

C:\Users\ed>sqlplus sys/password@orcl as sysdba
...
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections

ORA-12528 means that the database is at NOMOUNT state, there's no way to connect to a NOMOUNT database for normal users at client side. On the other side, there's a way that can allow SYS to connect to a NOMOUNT database externally.

In such moment, the connection to the service of database is BLOCKED in the listener, which means, normal connections will be rejected. For example:

SQL> conn hr/hr@orcl
ERROR:
ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Let's check the service status of database in listener.

[oracle@test ~]$ lsnrctl status
...
Services Summary...
Service "ORCL" has 1 instance(s).
Instance "ORCL", status BLOCKED, has 1 handler(s) for this service...

The command completed successfully

Solution

For normal users who want to connect to the database, you have to open the database to able them to access. For connections by SYS, the solution is to add a special parameter UR=A in connect descriptor to lift off the restriction. More specifically, we added (UR=A) for a connect identifier ORCL.

[oracle@test ~]$ vi $ORACLE_HOME/network/admin/tnsnames.ora
...
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = standby01)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL) (UR=A)
)
)

Let's see how we connect the NOMOUNT database.

C:\Users\ed>sqlplus sys/password@ORCL as sysdba
...
Connected.

We solved it.

ORA-00845: MEMORY_TARGET not supported on this system

 The shared memory file system should have enough space to accommodate the MEMORY_TARGET and MEMORY_MAX_TARGET values. To verify: SQL> sh...