in

SRC User Group

A Community of Users

Error message when drilling on a drill sheet

Last post Tue, Nov 25 2008 10:37 AM by srcadmin. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • Fri, Nov 21 2008 11:27 AM

    Error message when drilling on a drill sheet

    Hello, I am having an issue with a fixed report. I can successfully drill in the "Report" tab along the "costctr" dimension, and that info comes up in a new sheet PLNDrill1. When I attempt to drill on a value within the PLNDrill1 sheet, such as "acct", I get this error message:

    The following error was encountered during calculation: Error while creating local database tables. od_all0.od_al (Field) is not a valid column in the database

    Does anyone know what is causing this and how I can fix it? Thx

    Walter Laughlin
    VP/Senior Financial Analyst
    Rabobank, N.A.
    915 Highland Pointe Drive, Suite 350
    Roseville, CA 95678
    Office: (916) 878-4625
    Fax: (916) 784-3385
  • Tue, Nov 25 2008 10:37 AM In reply to

    • srcadmin
    • Top 10 Contributor
    • Joined on Sun, Jan 27 2008
    • Portland, OR
    • Posts 121

    Re: Error message when drilling on a drill sheet

    Walter:  this is hard to diagnose without seeing that report.  Are you using a formula to derive the fieldname and perhaps the formula is creating a bad fieldname once it shows up on the new drill sheet?

Page 1 of 1 (2 items)
Powered by Community Server (Non-Commercial Edition), by Telligent Systems