Yes your points helped me to analyze the correct answer. And I marked your posts as helpfull. Thanks Again!

I have reviewed my time dimension hierarchy and in that at the month level logical key which is defined(Cal_Month) has the value like 12,11,10 etc. Since we need to have a combination of year and month in the logical level key . I have used the column(Per_Name_Month) which has the value like 2018/12,2018/11,2018,10 etc. So…

Thanks for the reply. If I remove "Person Visit Date" from above case statement mentioned. I get the correct results for “# of orders” and “# of Orders Previous Year”. Currently chronological key is set at detail level. So I have modified the hierarchy by putting chronological key at each level and tried, but there is no…

The column Product Expiry in periods is of double data type. I have tried changing it into integer and tried and still getting the same error. I am filtering for one product and trying to see the results. So for that product it will not have any null or negative numbers.

Thanks for the reply. Below is the error I am getting if I use a column instead of static number.

Thanks for the reply As we have several tables we are not going with this option. Does it mean until we purge the bi server cache this cache stays in there in the files?

Thanks for the reply Srikanth We dont have the 7963 OOTB RPD. And oracle also suggests to use a blank RPD for merge.

Ya will post the same question in BI Apps forum too. Just tried checking here. we don't have a common parent so used blank RPD and oracle document also says using blank if you don't have a common RPD.

Thanks for the reply Rmoff Its a genuine 3 way merge We are moving to new BI apps version. So we need to move our custom and out of the box custom objects to the new BI apps. So while merging, this custom and out of the box custom will be moved and when we have same objects in both RPD but in those objects there might be…

The modified RPD is the 7963 BI apps RPD and the Current RPD is the 11.1.1.10.1 BI apps RPD. Thanks

Can you check "biplatform" and "mds" password are connecting and they have not expired as they do at times. Thanks

Thanks Christian for the inputs. What worked for me is... I have created a new alias of the fact table (Fact Sales) and kept all the joins same as my original but not joining to the time dimension. I have defined the content level for the all the joined dimension to detail and the time dimension which is not joined to this…

I have created the level based mesaure "start to date" and set the level as grand total on it and the same is reflecting at the time grand total level. But I am not seeing the values at grand total level for each year the values are same as sales column only. For the this Fact sales's LTS I have time set content level as…

Thanks for the reply. Ya doing level based measure at time grand total level will give me total sales till date. And hopefully it should repeat for all the years the same aggregated total sales value when I have year in my criteria. But when I include any dimension column like country and state in the criteria it will not…

Hi Andrew, Thanks for the reply. Now I am able to pass single and multiple values but not all column values. Below is my code AND st.name in (@{Site_DBR}['@']{'SSP10'}) or (@{Site_DBR}['@']{'SSP10'}) is null And when I remove the or part the code works for multi select. Any suggestions. Thanks

Thanks Gianni for pointing to required OBIEE Samples. I will try to download this VM and check for the scripts.

4. Re: 3 Way RPD Merge in 11g and 12c rmoff Nov 23, 2016 9:54 AM (in response to 2845107) For a three-way merge of this type you'd usually use a common parent, rather than blank, as the original RPD, so that the admin tool can establish correct lineage and commonalities. Answer) we don't have a common parent so used blank…

Agreed Gianni... Since my question is more relevant to OBI Apps so posting here again. Below are points to add up to the above question. . Re: 3 Way RPD Merge in 11g and 12c rmoff Nov 22, 2016 8:23 PM (in response to 2845107) Question) What are the RPDs that you're actually trying to merge? Is it a genuine three-way merge,…

Hi Gianni, Thanks for the reply. I have 11g installed in my machine and having sample app. so checked in installed folder but could not get them. Can you help me with the path where I can find these scripts. Thanks

Thanks Gianni for the reply. Looks like we only have two options and that is manually recreate by looking into 11g rpd and copy/paste by hand wherever necessary. Thanks