Questions on IDEA Analysis

Hi,
I have an issue with chart. 
I have set a summarized column (No of records) as Y axis value for the chart.
Y axis value is shown with decimal places. Is there any way to specify number of decimal places in the Y axis. As shown in the picture, it is showing like 0.10, 0.20, 0.30,...1.00. 
I think this is showing when value is very small.
Please advice if there is any way to change this behaviour from script. 
Thanks,
Shafeer

Hi,
I have an idea script with the following steps
1. Create a chart based on a database, say db1.
2. Execute extraction on another database, say db2.
3. Open chart of db1
4. Open extracted database from step2.
Problem I am facing is that, the chart generated is not showing up while opening db1. It is showing data instead of chart. Is there any way to show chart by default?
I am using Client.OpenDatabase(db1) to show graph.
Thanks,
Shafeer

Hi,
I am summarizing a file based on a column 'Category'.
Categories will be A, B, C, D, etc
So summary file will have records like given below.
Category    No of records
A                     10
B                     20
C                     15
My requirement is this:

Hi All,
Hopefully this is the right area for my question..
I've got two datasets in IDEA; Employee sickness which details employee name and the date range they were on sick leave and purschasing card transactions which details the name and purchase date (obvisouly amongst a lot of other info).
I want to compare the two to show transactions where the employee was on sick leave.  I know I will need to match on name and probably use @betweendate to find the transactions made between the sick dates.

Hi Brian,
Hope you are doing good!
I'm trying to export an IMD file to Excel and trying to format the Excel via IDEA.
I want to display User name, Date and input /output file name in the excel file.
I figured out ways to display current date, input and output files names but, unable to find a way to display the username.
When we open History tab we see database, date and username displayed.
Ther must be some way to display the username. If someone know it, please let me know.
Regards,
Sridhar

I am writing my dissertation and part of the methods involves forecasting (oil price). Is it possible to get information on the method that IDEA uses to come up with the forecasts? Does it use mean reversion, geometric brownian motion or something else? I will be glad to receive a detailed answer to that effect.

Hi all,
I would like to create some Attribute sample in IDEA- Someone does have more information/hints on the usage of this fucntion (Planning - Beta risk control...).
Thanks for your help!
Laetitia

Hi, in version 8, I am trying to run SmartAnalyzer for General Ledger on a GL database.  I choose certain extractions and go to define tags and whenever I click on Field Name (where it says “<No Field>”) nothing happens.  See screenshot attached. Can you please help?  Thanks.

 
Hi Brian,
I´m sure you can help me with this.
Have a list of payments to vendors made by users and I would like to extract vendors who have been paid by only one user.
Any simple way to do this in Idea?
Thank you in advance.
Fernando
 

Hi Brain,
I want to extract records that satisfies my equation which has @getnext function, looks like when I perform a direct extraction I uanble to becoz of the behaviour of@ getnext funtn.
Eg. I am trying to extract invoices across records that are within 2days timeframe. I sorted my db with INV date then I created a field called check with eqn = @if(@age(@GetNextValue("INVOICE_DATE"),INVOICE_DATE) <=2,1,0)
Invoice date    Check
1/31/2006         1