Executive Viewer Client

[anoops81]

Hi All ,

I am getting the error message :

Invalid outline definition
Additional information:

Parent Unique Name '[Projects].[All Projects]' specified for member '[Projects].[UST - Strategy and Services]' could not be found in the member chain.

This error is occuring intermittent. I doubted the problem is with the EV view , But the error still exists. Any suggestions on this ?


Thank s& Regards

Anoop

[Steve Vincent]

Not used EV but it sounds like "All Projects" is missing from the dimension...could it be disappearing / reappearing as part of something else (TI updates for instance) which is causing the error messages?

[anoops81]

Hi Steve ,

I have written some element level security rules for the "projects" dimension and the user has no access to the consolidation element "ALL Projects" . He will be able to see those projects in which he is working. I think , so EV is not able to bring the consolidation element to the view.

Thanks & Regards

Anoop George

[RLReyes]

Invalid outline definition
Additional information:

1) Have your check the EVServerLog?
2) Are your EV views set to "Preload"?
3) Are you using workflow?

[anoops81]

Hi Rod ,

1) I have checked the evserverlog . The log is not showing any relevent information regarding the error.
2) Views were not set for preload. I have to set them for preload ?
3)I have installed work flow. But we are currenly not using workflow.


Thanks & Regards

Anoop

[tm1expert]

The root issue is that when EV doesn't have a full copy of an outline available, it cannot make TM1 happy when requesting an outline that has restrictions on it. TM1 wants to always be able to give a full outline to external applications and in the case where EV does have a full, referencable copy of a given outline, EV can substitute in place-holder members when requesting incomplete (restricted) outlines from TM1. In the case where EV either doesn't have a full copy or the copy EV does have is marked out of date, when EV tries to get a member for which it has no parent information, TM1 throws that 'Parent Unique Name....' error.

The workarounds are as follows:
-cycle EV to reload all outlines (least desirable, I am sure...)
-have a TM1 admin open the report. this will ensure that EV has a full copy of the outline for that cube going forward (or at least until the outline is out of date)
-use the ForcePreload URL command to force EV to get a new, full copy of the outline then and there
-Use the CheckPreloadingTimeout parameter, but this might not cover all cases; timing of the preload in EV and updates on the TM1 side might still allow a slice of time where one could hit this issue

The 3rd option is likely best and as well can be 'automated' after a fashion.

Given the following .vbs script, you can tell EV to force a preload of a given object. What the script does is create an instance of IE and pass the URL command to EV. After creating such a script, you can use the ExecuteCommand method in TI to call a batch file, which then calls the .vbs script (we cannot call .vbs files directly from TI). Once you have that piece in place, you can tie that TI to anything that updates the outline and would cause the aforementioned issue, a bulk-data load, an action-button adding an element, etc...

Here is the .vbs script:

Dim ieObj
Set ieObj = CreateObject("InternetExplorer.Application")
ieobj.visible = true
ieObj.Navigate2 "http://localhost/EVServer?action=Update ... ts%20Sales"
wscript.sleep 2000
ieObj.Quit
set ieObj = nothing

Ensure that you update the URL to point to your EV server and the proper database object. For reference, my URL forces a preload against the localhost (my laptop) for the database object 'retail\Products Sales' within the System folder in EV Explorer.

Last, ensure that the security context of the TM1 server has administrator rights over the EV object. If the TM1 service runs under a service account, apply admin rights to the database object to that account, otherwise if the TM1 service is running under Local System, ensure that 'NT Authority\System' has admin rights

[Bert]

From the readme.txt

When you apply element security on Dimensions within an Applix TM1 cube,
where ancestors of available (read/write) elements are made unavailable as part
of the security profile, you must do the following:
1) Preload the cube;
2) If meta-data of the cube is expected to change during the usage of the cube,
set the 'UseCurrentOutlineWhilePreloading' to true in the 'appSettings' section
of the 'EVServer.exe.config' file:
<appSettings>
<add key="UseCurrentOutlineWhilePreloading" value="true" />
</appSettings>

HTH

Bert.

[anoops81]

Thank you all for the replies and suggestions.


Regards

Anoop