28
Oct2013
0 comments
Downsizing Dangers
Downsizing Dangers: Think About Those Left Behind
read more
18
Oct2013
0 comments
Dynamics NAV NAS/Job Queue - Excel SaveAs method failed
NAS/Job Queue entry error when creating Excel files using the Excel Buffer.
read more
16
Oct2013
0 comments
New in XLCubed 7.5
XLCubed version 7.5 is now available! We explore the highlights of this new version including web and mobile analytics, interactive charting, and publication and sharing of PowerPivot.
read more
15
Oct2013
0 comments
How to suspend and resume SQL database mirroring
There are times when you need to perform an operation that requires database mirroring to be suspended. A good example is when putting the database into single user mode.
read more
11
Oct2013
0 comments
XLCubed: Excel Dashboards
We're huge Excel fans, but don't believe it makes for a good database. XLCubed Excel edition extends the strengths of Excel, adding advanced analytics, and mitigating the weaknesses by connecting directly to server based data.
read more
10
Oct2013
0 comments
Analytical Applications of Business Intelligence Reporting
The following examples show how XLCubed is being used to provide Business Intelligence solutions to our customers.
read more
10
Oct2013
0 comments
What is Microcharts? How can it clarify data?
When used in addition to Excel's native charting engine, MicroCharts can turn Excel into a truly world class dashboard development environment.
read more
02
Oct2013
0 comments
Can’t print from XLCubed Web Edition
When you attempt to print, nothing happens and no error message is seen.
read more
25
Sep2013
0 comments
OLAP or SQL
Today the choice for a business intelligence application is largely perceived as between a Relational and/or Multi-Dimensional databases. Here we explore the differences between the two.
read more
22
Sep2013
0 comments
NetIX force manual process
If you need to pick up the outbound files or make the inbound files (BOS Batches) quicker than the 30 minutes
read more
25
Jun2013
0 comments
The whole Job Queue stops when a lock time out occurs
Running NAS with Job Queue will start a timer to process Job Queue Entries every two seconds.
In the original code the Timer is disabled before checking the Job Queue Entries and then enabled again after the process.
read more
21
Jun2013
0 comments
Dynamics NAV Deadlocks and Blocking
There are a number of things to try when dealing with locking in NAV2009, NAV2009R2 and NAV5
read more
20
Feb2013
0 comments
Missing permissions in NAV2009R2
By default Ms Dynamics NAV 09 R2 is missing several permission records for tables that are new in R2. Even in the CRONUS database for NAV 09 R2 these permissions are not included.
read more
16
Jan2013
0 comments
XLCubed Right Click menu missing
When you right click a cell containing an XLCubed formula, the right-click menu for XLCubed should appear.
read more
27
Dec2012
0 comments
NAV Job Queue says “In Process” but job has crashed
If the job encounters an error the Job Queue Entries page will continue to say the job is "In Process". In fact its not and it will never run again until the job is reset.
read more
12
Nov2012
0 comments
Settings to access printer are not valid
We were trying to print from a dotnet assembly. This assembly was being used by a webserver/service running on Windows 2008R2.
Tried applying the registry hack described in http://support.microsoft.com/kb/184291/en-us But was still receiving the error
read more
24
Oct2012
0 comments
Generate xsd from NAV Tables
If you need to generate an xsd to represent a NAV table, use the following SQL command
read more
07
Mar2012
0 comments
Manually install xp_ndo
Sometimes you need to manually install the extended store procedures use by NAV Integrated Security.
read more