Topic
1 reply Latest Post - ‏2013-01-07T14:15:39Z by GOICEHOCKEY
GOICEHOCKEY
GOICEHOCKEY
135 Posts
ACCEPTED ANSWER

Pinned topic Dimenaional Hierarchy Report and Invalid member reference (HELP)

‏2013-01-03T18:28:07Z |
Friends,

I thought I had this problem fixed but it is not. I am getting the following error,

At least one invalid member reference was encountered in the query.'Cube-xx-xxx-rollup.Iss_Date.Iss_Date.Day->:PC.@MEMBER.20130103' The code looks like the following,

prompt('BeginDate','date',$current_timestamp,'','','T00:00:00Z'),'yyyymmdd'))#,

Is it because there is no data associated to the specific member,
].20130103

Is there any kind of workaround I can use at the cube creation level or the actual report
to handle this error.

Thx in advance for your time.
Updated on 2013-01-07T14:15:39Z at 2013-01-07T14:15:39Z by GOICEHOCKEY
  • GOICEHOCKEY
    GOICEHOCKEY
    135 Posts
    ACCEPTED ANSWER

    Re: Dimenaional Hierarchy Report and Invalid member reference (HELP)

    ‏2013-01-07T14:15:39Z  in response to GOICEHOCKEY
    I added a java script to alarm the user that the begining date needs to be at least one week old since we refresh our cubes in a weekly basis. This way, the end user search won't try to retrieving the cube data that doesn't exist in the cube yet?

    Let me know what you think?