General discussion
Getting the Brass to Buy into Data Analytics
Forums
Interesting article in accounting today about getting management to buy in with the use of Data Analytics. http://www.accountingtoday.com/accounting-technology/news/getting-the-b…
- Read more about Getting the Brass to Buy into Data Analytics
- Log in or register to post comments
Interesting Data Analytics Blog
Forums
David Coderre who is a long time data analytics guru is writing a blog about his career. He recently retired from the Canadian Federal Government. You can check out the blog here: http://caats.ca/blog/
- Read more about Interesting Data Analytics Blog
- Log in or register to post comments
Getting the name of the running script
Forums
Hi Brian
Is there a system field that holds the name of the running script?
for example: I have few versions of the same script. They are all having the same name suffixed by V1, V2, V3, etc.
The scripts generate excel files and I want to make sure the generated excel files are stored in different folders, depending on which version of the script is running.
Thanks a lot!
Avi
- Read more about Getting the name of the running script
- 4 comments
- Log in or register to post comments
IDEA Script - Integrated Development Environments
Forums
Does anyone know of an IDE (Integrated Development Environment) that integrates IDEA Script? I wasn't able to find anything of use when it comes to the generic IDE's out there.
Essentially, I am looking for:
- IntelliSense (or something similar)
- Debugger
- Stack Watching
- Library references
- and all of the rest of the generic goodies.
Thanks and I'll be waiting to hear back,
Special case of strip
Forums
Hi Brian, how are you?
I have a problem. I want to remove the character " from a field. I do not wisht o use @strip because it removes all special characters. I could not find a function that will accept " as the character to handle (replace, remove, etc. - they all failed)
Thans!
Avi
- Read more about Special case of strip
- 8 comments
- Log in or register to post comments
V10.1 is now available
Forums
Looks like IDEA has released V10.1 and from what I was reading it has added lots of new features for the visualization part of the app.
Check out the blog for more info and screen shots: http://www.casewareanalytics.com/blog/product-close-what%E2%80%99s-new-…
- Read more about V10.1 is now available
- Log in or register to post comments
Benford's Law: A Real Life Case Study
Forums
I saw this article and thought it might interest some users.
http://acfeinsights.squarespace.com/acfe-insights/2016/1/15/benfords-la…
- Read more about Benford's Law: A Real Life Case Study
- Log in or register to post comments
New to IDEA Scripting
Forums
Hi there,
I am new to IDEA and IDEA scripting. I have a fairly extensive background though with using ACL and scripting in ACL. I was wondering if there advice that you could give me on some approaches to help me get up to speed with learning how to script in IDEA and also the differences and comparisons between scripting in IDEA and ACL.
One of my first observations is it does seem like the script code for IDEA is longer than what is required in ACL for doing similar tasks.
Any advice, tips or assistance will be greatly appreciated.
- Read more about New to IDEA Scripting
- 10 comments
- Log in or register to post comments
Joining database with a date-period
Forums
Hello
I need to join 2 databases where the first has a date and the second has a period. The joining has to be done where the date of the first database is within the period of the second database.
So: database 1 has date 1 oct 2015, database 2 has 2 dates, date_from 5 jul 2015 and date_to 15 dec 2015 then the join is ok.
Has anyone any idea how to solve this in Idea, version 8 or 9?
Thanks !
Wim
- Read more about Joining database with a date-period
- 7 comments
- Log in or register to post comments
IDEA versus Spreadsheets
Forums
I just noticed this morning that Caseware Analytics have a new white paper entitled: Driving Better Data Analysis: Moving Beyond Spreadsheets, it compares using a spreadsheet with using IDEA. Good read for anyone wondering why they would use IDEA instead of Excel. (http://www.casewareanalytics.com/sites/default/files/whitepapers/caseware_analytics_driving_better_data_analysis_web.pdf)
- Read more about IDEA versus Spreadsheets
- Log in or register to post comments