Essbase

Get Involved. Join the Conversation.

Topic

    Dhamu Chinnavelusamy
    Essbase error(1260046) - Unknown member used in...
    Topic posted August 27, 2018 by Dhamu Chinnavelusamy, tagged Essbase, Smart View 
    418 Views, 2 Comments
    Title:
    Essbase error(1260046) - Unknown member used in query
    Summary:
    Essbase error(1260046) - Unknown member used in query
    Content:

    Hi, I am trying to build a SmartQuery connecting OAAC-Essbase. While trying to select Base members for a dimension, it is throwing this Essbase error(1260046) - Unknown member used in query. This is happening only when a parent member (ex.: Testing) is selected which contains a child member (e.x: Testing) with same name. Please note that the Essbase cube is enabled with Duplicate members. 

    Thanks, Will appreciate timely help.

    Image:

    Comment

     

    • Saresh Namboorissery

      Hi,

      Are you using  Oracle Fusion General Ledger Cloud Service ?

      You may review Use Of Two Different Datasource Types In The Same Financial Reporting (FR) Grid Returns Error: "Essbase Error(1260046): Unknown Member Current Point of View for Entity used in query" (Doc ID 1367601.1)

      Thanks,
      Sareesh

    • Glenn Schwartzberg

      It sounds like you have duplicate member names enabled (I hate that).  but for your smartquery to work, you have to have the full pathing to the member like [Testing].[testing0   you might enven have to have the full path from the dimension down to the member