Jigsaw Blog

18

Oct
2013
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

Oct
2013
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

Oct
2013
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

Oct
2013
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

Oct
2013
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

Oct
2013
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

Oct
2013
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

Sep
2013
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

Sep
2013
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

Jun
2013
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

Jun
2013
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

Feb
2013
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

Jan
2013
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

Dec
2012
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

Nov
2012
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

Oct
2012
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

Mar
2012
0 comments

Manually install xp_ndo

Sometimes you need to manually install the extended store procedures use by NAV Integrated Security. read more

24

Nov
2011
0 comments

Enable and Disable Service Broker

How to enable and disable service broker read more