datamart

[lekie]

Dear All,

    I have added routing point such as 811800 in CME when I used Hyperion to query data it shows that routing point in routing point template.
      My question is when I delete RP 811800 in CME why in Hyperion still have that RP and How long will be disappear.
      If I deleted RP 811800 and add it again so in Hyperion it will show 2 RPs (811800 and 811800)? and how can I know which one is a new one?


Best regard,
Lekie

[catanirex]

Hi,

If you only want Hyperion to show the current object, you need to add this in the reports. Only display object with delete_time NULL.

But since it is Historical reporting, the RP have been existing!

If you select both RPs, I think that Hyperion will join the stat and present it as one RP.
Thats how out Hyperion reports works

[sweetsbulu]

Hi,

I am agree with the above comments suggested.

Because Hyperion is for Historical reporting if your deleted from CME but not from Datamart i think so.
Check OBJECT table and Obj_To_Obj table for more details according to the presentation name or object id.


Let me know any issues.

Thanks
sweetsbulu

[sweetsbulu@gmail.com]

Please check the Object table where you will get the child id and parent id.

According to that check if there is 2 objects are there means the prevoius object is not deleted.

Thanks
sweetsbulu

[lekie]

Thanks you all guy