Since Time is sometimes not stored as a numeric value, I would try something like SELECT "Time"."Fiscal Year" FROM "Financials - GL Balance Sheet" WHERE "Time"."Fiscal Year" LIKE ‘20%’; Sarah Craynon Zumbrum | Enterprise Cloud Architect Public Sector BI/Analytics Mobile: +1 919 917 6571

I would check to make sure that the following ports are open for Essbase: 1423 (necessary to create the connection) 32768-33768 (necessary to pull back outline members and data in DV) Also, your connection string should be server:1423 Blog link:…