"Hi Scott,
I would create your extract for consolidation using the standard Alchemex method - ensuring each company has a unique identifier. Once you have this, you can create a report/sheet with multiple columns that look for each individual…"
Allan Smallie's Groups
-
Alchemex Certified Profe…
46 members
-
Alchemex for MYOB EXO Bu…
11 members
-
Free Report Templates Gr…
116 members
-
Sage ERP Accpac Intellig…
135 members
-
Excel on Steroids
150 members
Allan Smallie's Discussions
TBSync2 - Copies top row (in this case a heading)
Hi All, I am using TBSYNC2 to duplicate a column of data across onto a report sheet.This is working well, except for an odd result. It appears to be copying the top row, in this case a heading! See…Continue
Started Dec 14, 2011
Alchemex SVD reporting
Hi All, I am working on a number of reports, and we are using various links to MYOB/MYOB-EXO and EXCEL.These reports are then joined into a UNION for final consolidation. I am looking for an easy way…Continue
Started Nov 22, 2011
EXO Unlock Standard Reports
6 Replies
Good Day,We have written a number of custom reports, using some of the standard formats/connectors. Most (but not all!!) reports were initiall copied, hence unlocking them.We have now discovered that…Continue
Started this discussion. Last reply by Allan Smallie Sep 16, 2011.
Alchemex Report Tools - Excel Add-In
1 Reply
Hi All, I am using Excel 2010 and once I have generated a report, I cannot seem to get the Add-in to show, or to allow me to select it.Specifically I am trying to provide drill-down functionality to…Continue
Started this discussion. Last reply by Allan Smallie Mar 10, 2011.
Allan Smallie's Page
Latest Activity
Allan Smallie replied to scott suekawa's discussion side by side consolidation example 3 companies plus elimination Mas90Allan Smallie replied to alan niergarth's discussion ODBC connection to IBM AS400?"Hi Alan,
Seeing as you have an ODBC driver available, I would try setting up a traditional ODBC connection to the AS400.
Once this is working, you can create a connection with Alchemex Administrator under the 'System DSN' options (down the…"
Allan Smallie replied to Cliff van der Poll's discussion Comparing 3 values and returning a result"Hi Cliff,
You try using something like =IF(AND(H5,I5,J5),"True","False")
There is also the SUMIFS formula, which is useful for calculations
Depends on what outcome you are after.
"
Allan Smallie replied to Rosemary Stimpson's discussion Sage Accpac Intelligence - v6.0A"Hi Rosemary,
Sage Accpac v6.0A ships with Sage Intelligence as a included module. This has a number of standard reports/dashboards that are made available to run against your Accpac Data. These reports will run against whatever Accpac company you…"
Allan Smallie replied to John O'Carroll's discussion Template not saving changes"Hi John,
If you are making changes to SHEET1, all modifications will be over written next time you generate the report.
The sheets are typically used to store extracted data, and any formats/pivots/font changes etc need to be created in a separate…"
Allan Smallie replied to John O'Carroll's discussion Trying to add a parameter to a report - no fields available to choose"Hi John,
Have you created a Pass-Through Variable in the APVEND container?
These pass-through variables will appear when you then add a field to the parameters section.
"
Allan Smallie replied to Peter Sheridan's discussion Read Alchemex.svd file"Hi Peter,
This SVD file is an encrypted MS-Access file. Alchemex have locked this file, as it contains all the container, expression and template data for each report that is created.
I would imagine that this is encrypted to ensure integrity is…"
Allan Smallie replied to Leo Demarce's discussion Security Not allowing Macros to run"Hi Leo,
My experience with this has been that the files need to be 'trusted' on each workstation that opens them. This translates to users having to click on the "enable" option, and they would not be prompted again. You can also…"
Allan Smallie replied to Allan Brown's discussion Pivot table from sheet 1 and sheet 3"Hi Allan,
I would look at combining Sheet1 and Sheet3. Alchemex will allow you to deliver both union reports to the same sheet!
Columns need to be the same, and in the same position - but this way, you are combining 2 sources of data.
The…"
Allan Smallie replied to Maree Palmer's discussion Accpac AR Invoices and Customer Optional Fields"I would build this into a VIEW or treat it as a select statement, as it would be easier to add tables/optional fields in the future!"
Allan Smallie replied to Maree Palmer's discussion Accpac AR Invoices and Customer Optional Fields"Hi Maree,
Based on sample Accpac Data, the below view allows you to 'flatten' optional fields for each item.
This shows 3 fields, however you can see its easy to extend to include more.
Again, linking back to sales history would prove…"
Allan Smallie replied to Jaime Schmulson's discussion SAI vs. Crystal performance issues."You are correct in that ALX does have an increased overhead due to the process of retrieving the data. This said, I've never had an issue with this before, as the added functionality provided is significantly more important that a longer…"
Allan Smallie replied to Jaime Schmulson's discussion SAI vs. Crystal performance issues."A few thoughts...
Look at the configuration of your ODBC connections that are used within the container. Perhaps they are causing the bottleneck. Are they the same ones used by Crystal?
Are your views running efficiently? ie not cumbersome and…"
Allan Smallie posted a discussionTBSync2 - Copies top row (in this case a heading)
Hi All, I am using TBSYNC2 to duplicate a column of data across onto a report sheet.This is working well, except for an odd result. It appears to be copying the top row, in this case a heading! See attached screenshot showing "NameID" which is the row that in un-wanted! Is this by Design? and if so, how do I work around this? Any ideas? …See More
Profile Information
- Alchemex Powers the Following BI Solution, Pick Yours
- Wage Easy-Easy Business Analyzer, MYOB, Sage Accpac Intelligence, Excel On Steroids
- Website
- http://www.adsassoc.com.au
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
