Hi, The above approach is definitely not an easy one. By the way, should we avoid specifying implicit fact table then? I am not sure about its use now. And if we were to remove it, how can undertake doing an impact analysis? Could you share a few tips please? Thank you. Regards, Manoj.

Hello Christian, Thanks for your reply. I am thinking of exposing dwh key of the new prompt's dimension in the presentation layer and use it in a logical SQL to build the new prompt. The idea is to run the Analysis based on the other prompt values and create the LOVs for the new prompt. Then let the users select particular…

Hi Gianni, I have resolved the issue now by replacing the two column based prompts by variable prompts. And now I can see the Sales Person LOV. Regards, Manoj.

Hello Gianni, It's a Client requirement as the number of rows is too high and the values are not user friendly to remember (actual dimension is different). It consists of some codes with descriptions concatenated. So the Client thinks that it will help the end users to select options from a limited number of choices. The…

Thanks for the slideshare link, Gianni. Solid presentation. As I said I need to spend time to get practical experience, (but at the same time, we delete everything in the Identity Manager from a copy of the development RPD at the time of packaging and I assume that it's due to some valid point) for now, I would like to…

Hi Gianni, Thanks for the example. An Analysis based on FactSales and DimCustomer is correctly being applied the data access filter by the BI Server, as the FactSales logical table is based on an LTS that is joined to DimBusinessUnits (on which the row-level security is based on). The scenarios where the BI Server is not…

Hi Christian, I think I am now understanding what's being conveyed here. So, currently, a fact logical table's LTS is joined to a dimension (on which data access is restricted) and a WHERE clause condition is populated with a filter. Now when an end user selects the fact table's measurement and other dimensions' attributes…

Thanks Gianni. Yes, a developer forgetting to add the WHERE clause condition to all / single LTS can be an issue. Regards, Manoj.

Hi Thomas, I like and appreciate the help being provided. But to be honest I feel that the current data access model (based on LTSs) seems to be more easy to create and maintain (which, at the moment, is simple). With respect to the Identity Manager and Data Filters, I feel that I have to come out of a developer mode and…

Hi Christian, Yes, I shall close this thread. I thought I shall complete some hands-on first. No access to slideshare, etc. due to employer's policy. I am sure your, Gianni's and Thomas' inputs will help me cross the finishing line, bit slowly but steadily. Regards, Manoj.

Gents, thanks for your valuable inputs.

I believe my first question is wrong. As, if I create a row-level security via 'Data Filters' for BIConsumer role then automatically it will be applicable to BIAuthor role as well? Is that correct?

Thanks Christian. Using Identity Manager, do I need to duplicate 'Data Filters' with respect to all the Application Roles? For example, a user belonging to BIAuthor role should be restricted from seeing region Americas data and so, a user belonging to BIConsumer role. And, can the data security still be enforced even if I…

Yes, I agree with the above.

Sorry little curious and do not offer a direct solution. But, aren't they all different addresses? Hudson 5 or 5 Hudson may not be Square, but could be street, road, bay, river, hill, lodge, b&b, corner, villa, mount, etc.. Would it be a better idea to have two prompts, for example, one for house number and another for a…

Thanks again, Andrew.

Thanks Andrew for confirming. I am asked a question why Oracle did not release OBI EE 12.1 first before 12.2. Regards, Manoj. Edit: There is Oracle database 12.1. (A comment and question from my team.)

Pre-canned report = a report built for a user or a group of users upon request by IT department. Ad-hoc report = a report built by a user which was not planned or requested for before. For example, a report is pre-built to display production quantity by day and hour. An end user notices that during 12 noon and 13,…

No problem. My reply was based on words like 'navigation', 'analysis with column prompts', 'go back to prompts page', etc. You can create Analyses with prompts and embed them within dashboards. Else, the option within an Analysis would have been meaningless. For new comers, it helps to understand the concept. I consider an…

Hi Jessica, Thanks for marking my first reply as helpful. I feel, based on your question, it is technically a correct answer. Had your question been about differences between the two types of prompts, my first reply would not be the same. Regards, Manoj.