Question Status

Verified
Nasha Hamra asked a question on 16 Mar 2015 4:01 PM

Can anyone please tell me the tables and calculations used to generate this graph.  Client has been using it for a few years but a few weeks ago it went nuts.  I am trying to trouble shoot the cause but not having any luck.  Sales Reports - Analysis and History that show Profit % and dollars look normal.

Reply
Suggested Answer
Arunprasath responded on 17 Mar 2015 3:30 AM

Nasha,  I suggest you to use Profile Scripts and Sql server profiler while running the KPI.  By using them you may  get the table details.

Reply
Verified Answer
Nasha Hamra responded on 19 Mar 2015 9:38 AM

The answer to this question is GL Categories - it is not directly tables.  I opened a ticket with Microsoft and as soon as he mentioned categories it was simple to see the problem.

Reply
Verified Answer
Nasha Hamra responded on 19 Mar 2015 9:38 AM

The answer to this question is GL Categories - it is not directly tables.  I opened a ticket with Microsoft and as soon as he mentioned categories it was simple to see the problem.

Reply
Suggested Answer
Arunprasath responded on 17 Mar 2015 3:30 AM

Nasha,  I suggest you to use Profile Scripts and Sql server profiler while running the KPI.  By using them you may  get the table details.

Reply