Alchemex Report Writing (271)

Discussions Replies Latest Activity

System Variables - Giving Error 7481 - Inconsistent Types

I'm getting an error in my connector when I try to use the '@MONTHSTART' system variable: I have the following SQL statement (Which works…

Started by modhorat

7 Jun 15
Reply by Peter Scully

Financial Report Designer

Hi everyone I am using Sage Pastel Partner V14 and also the sage BIC module.  I have recently designed a new report using the financial re…

Started by Camy

4 Jun 5
Reply by Camy

Default Null to Zero

Greetings Anyone know of a setting, or way to default all Null values to zero? I have some long and complicated SQL Expressions, and I woul…

Started by Anthony Whitehouse

1 Apr 11
Reply by Tesh

Using Report Designer for specific X3 folder

Hi all, Doing some reporting for a company on Sage X3. How do I specify in the Report Designer to use a specific Folder for the database? W…

Started by Awie van den Berg

1 Mar 23
Reply by Tesh

OLAP platforms and Alchemex???

What platform does Alchemex use for OLAP 1. SQL or 2. Pivot tables in Excel? or 3. Other? 4. ODBC

Started by Ruth Gray

7 Mar 8
Reply by Leroy Gordon

SQL statement

Hi:  I am trying to get past an error where Intelligence isn't able to format a date field, because in some cases the field is zero.  I am…

Started by Dane Hoover

2 Jan 5
Reply by Dane Hoover

Availability to other users

Hi   I've just started using BIC and I'm sure I'm forgetting something really basic but haven't the time to keep trying to figure it out. I…

Started by Wendy Carr

3 Sep 1, 2016
Reply by Willie Oosthuizen

Extracting data from an Excel file

Hi everybody, I have only worked with SQL databases to generate BI reports. Is it possible to extract data from an Excel file to generate…

Started by Prabha VIRAH SAMMY

3 Jul 7, 2016
Reply by Prabha VIRAH SAMMY

unique list of customers

I am looking for a way to produce a list of customers that has unique customer IDs and names. All I get is list with same customer name or…

Started by Ernesto Quinonez

3 May 16, 2016
Reply by Carmen Griessel

Automatically send a report to every salesperson about their orders

Hi, I need to automate a report which need to be emailed to each salesperson. Just gives them details of their orders from the current dat…

Started by Prabha VIRAH SAMMY

4 Mar 22, 2016
Reply by Shwu Hua Gan


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2017   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service