Skip to Content
author's profile photo Former Member
Former Member

EVLCK in BPC 5.1

Hello!

It seems impossible to use the EVLCK function in a report so that a user can

see the workstatus of all entities even though the user hasn´t got the

access to the entities in the member access profile?

Does anyone have an idea how to work around this to create this kind of report? Beacause we want our user to change workstatus on their own entities and be able to see the worksstatus on all other entities.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 04, 2008 at 12:21 PM

    Daniel,

    I know that Joost Hoppenbrouwers recently did this in V5.

    @JOOST; hope you can post the trigger code you are using.

    Below some code I used in the 4.2 days, the difference with V5 is that each application had his own locking table now, so it needs some adjustments:

    CREATE TRIGGER STATUSDUMMY ON dbo.tbllckfinance FOR INSERT, UPDATE, DELETE AS INSERT INTO tblStatusHistory SELECT a.category, a.entity, a.Status, a.Lastupdate, a.UpdateBy, a.Time, a.TimeName FROM tblStatus a WHERE a.Lastupdate not in (SELECT LastUpdate from tbllckfinancedummy)

    Alwin

    Edited by: Alwin Berkhout on Jul 4, 2008 2:22 PM

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In addition to my previous post: of course the dimension names might be different in your application, based on which dimensions you use for the workstatus. In this case just rename the dimensions in the trigger code. If you take a look at the design of the tblfinancelock table first you will see which dimensions you need.

      -Joost

  • author's profile photo Former Member
    Former Member
    Posted on Jul 04, 2008 at 08:15 AM

    Daniel,

    Standard this is not possible because you need authorization to see an entity, to see the workstatus.

    Possible solution might be:

    - Create an extra cube with the same dimensionality

    - set the security in this cube for the entity dimension so that everyone is allowed to see all entities

    - create a trigger on the lock table of the original cube to update automatically the lock table of this new cube

    Hope this helps,

    Alwin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2008 at 12:28 PM

    It worked fine! Thank you!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.