Hello Dodds, Thanks for your reply. The facts and dimensions in both the images are same. However, the result is not. I don't want to display the fact(supplier name) info on rollover. I have added it for writing a case statement. So, it is not wanted in the output.

Thanks!! How could I add It to the view, where a drop down will be provided to select between graph or table.

Hi, How to reflect/pass the data in the duplicate layer to the graph or to a column which can influence the graph. The value in the % Overdue to Total is being calculated on a whole but I want only for TOPN. Please notice the difference in values for the same AP Overdue Amount. Thanks

Thanks for the replies!! I searched internet, couldn't find any detailed information regarding bins drill. Could anyone share any related content.

An extended question... How to customize the column names, as both the columns are representing the same names. Just like Revenue in your screenshot.

Thanks Mate !! You made my day...been working on this over a week.

Any insight would be really helpful. Thanks a lot!

Hi, In addition,The values for the product and product group are dynamically selected by the user from prompts which are built based on the product master. I am capturing these with in the presentation variables and passing the same in the sql query. Please suggest

Hi Berg, Sorry to bother you. I still not able to visualize, how this would serve my need. This is the sql query I am using. Please advise SELECT CUSTOMERS FROM TXN T1 WHERE PRODUCT_GROUP IN 'X' AND PRODUCT IN {'X1', 'X2'} AND DOC_DT BETWEEN TO_DATE ('2018/02/01', 'YYYY/MM/DD') AND TO_DATE ('2018/02/28', 'YYYY/MM/DD') AND…

Hi Berg, Thanks for your reply. I knew the concept of saving group of objects together and reusing them. I usually do this for saving group of filters. Could you please advise how could I make use of this doc to implement NOT EXISTS functionality or to meet the requirement.

Hi Charles, Thanks for the solution. It resolved my issue for now but need to dig in more on this for further requirements. Thanks

Hi Guys, Thanks for sharing your inputs. I have had raised an SR and ended up listening that it is not possible. As we are trying to place a measure column in rows which will not give desired result . Thanks

yeah the filter is as you mentioned

Hi, Here is the query auto generated in select distinct T460193.Expiry as c1, T155106.X_MEMBER_NUM as c2, T155106.X_PROGRAM_NAME as c3 from W_LOY_MEMBER_D T155106 /* Dim_W_LOY_MEMBER_D */ , (select a.member_wid as ROW_WID, a.expiration_dt as ExpirationDate, sum(a.accrualed_value) as AccruedValue, sum(a.x_used_value) as…

Hi Asim,

Hi Asim, the column is of type DATE. We are assuming that the actual issue behind the first issue would be this. thanks

Hi, At the db level the data is coming up correctly when the date filter is ExpirationDate between '30-dec-17' and '01-Jan-18' don't working when the filter is ExpirationDate between '30-dec-17' and '31-dec-17' please advise.

The physical query generated from OBIEE is as follows select distinct T460193.Expiry as c1, T155106.X_MEMBER_NUM as c2, T155106.X_PROGRAM_NAME as c3 from W_LOY_MEMBER_D T155106 / Dim_W_LOY_MEMBER_D / , (select a.member_wid as ROW_WID, a.expiration_dt as ExpirationDate, sum(a.accrualed_value) as AccruedValue,…

Thanks for you replies. Yes I do checked at DB level, as you guys suggested there are two records over there. My doubt is why two records are being pulled for only one member. According to the source OLTP DB this particular member the right value should be only 24. Please advise

Thanks for your reply. I will try the solution with XML. Mean while could you tell me without table view, which other view I need to use and how to format it.