Joining Calculation View and Input Paramters - ISSUE

[Former Member]

Hi All,

I am trying to build row level security without using Analytical privileges...The following is what I am trying to do.

Created a calculation view which will have user id, company codes, cost centers etc that the user has access to.

I have another calculation view which is where the security need to be implemented. So I joined both calculation views (there are matching fields between the views) and build the combined calculation view. I created input parameters and when I pass the input parameters the result does not show it reflects the filters given. On the data preview when I look at the generated SQL it seem correct but results does not show any sign of applying ALL filters.

Did anyone try this approach or join two calculation view and then apply input paremter on top of it?

Any suggestions, pointers?

Thanks,

Arthur.

[lbreddemann · Accepted solution]

You described what you intended to do.

But without seeing your code, your models and your data, there's no way anybody can reason what might not work correctly.

As usual: show the code, show the data, show the problem. Then there's a good chance for help.

- Lars

[Former Member · Accepted solution]

Lars,

Thank you for the note. let me prepare a detail document and attach it.

Arthur.

[Former Member · Accepted solution]

Lars,

I went back and changed the input parameter and adjusted the expression and it worked when single input is provided. I was trying for multiple costc enters to be passed to the calc view and it did not work. I am going to create an universe and webI and test fully and see whether multiple cost centers are passable and see whetehr it works.

Currently I am passing multiple cost centers to HANA and the model works well in production today, but this one has some issues.....

Will update how it goes....

Thanks,

Arthur.

[Former Member · Accepted solution]

I made it to work. Few things I overlooked. Thank you for all who contributed.

Thanks,

Arthur.