Hi Christian, Thomas, Cesar, Thanks for the Reply!! Though I understand the behavior of BI server,.. "Excluded" is purely a visualization mechanism and NOT a mechanism to control what gets fetched from the database" .....There are some difficulties I am having at Criteria Tab which gets me into this approach, which I feel…

Hi Christian, I am applying in the result TAB for different views, because there can have different formatting standard for headings and Values. Only in excluded section its not getting saved. Thanks Abinash

Hi Simon, Thanks for ur reply, I need to show only analysis to the users so i have hidden the folders. If i un-hide the folders, then all the folders will come for all the users, which is not the case. regards, Abinash

Hi Christian, Thanks for your reply. Actually I have created different folders department wise and placed reports under it. But some users are there who will have the access to reports from other department as well. So created in this way to achieve it . pls suggest any alternate approach. regards Abinash

Hi Felipe, Thanks for your reply. What I found, this concept might work in case of Dashboard, where we can link multiple analysis with a single dashboard prompt. But In my case, I have to build it in Analysis page with analysis propmt. is there any way out.... thanks, abinash

I have a column in DIM_TIME called, CAl_YYYYMM, which i have added as a 'Descriptor ID of" to Fiscal Month Year Column in RPD. The value of CAl_YYYYMM is like 201404. so if I Select MAY-2014, the PV will take the value of CAl_YYYYMM i.e. 201404. As the Prompt is Month range so it will be comma separated. i.e 201404,201512…

Thanks, Its working fine!!

Hi cesar, In your earlier reply You had asked to add the logical column to level. Is it possible to have your RPD screenshot and BI answer Screenshot for reference. Regards, Abinash

Hi cesar, That is exactly I did last time...already shown in images in last reply.. I am getting the output as sum of all the Years irrespective of Year. Please see the screenshot. Regards, Abinash

Hi Cesar, "AD_DIM_TIME Total" is defined as the grand total level, so i can't define any key for it. Shall I remove it as grand total level and try with it. And also if I keep it as Grand Total Level then I can not use it in Todate function. Please suggest. regards, Abinash

Hi Cesar, I implemented your suggested solution...as shown below both in RPD and its output in BI answer, Here Created By is the dummy column you had asked to create in Dim_Time table and its default value is 'obi_user' . Also shown the Todate function i have used in RPD to create the Logical Column "Total Sales" Is this…

Hi i have tried this...Its accepting at Edit Formula box, but getting following error while coming to result TAB. State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 22043] TODATE…

Hi Cesar, I tried with creating new logical column(Total Sales) in RPD with Todate Function with time level as the "Total" column created in DIM_TIME. What I found is... Even if I give Month ranges in prompt, Lets say for Two year :APR-2014 to DEC-2015, It will show me the data of previous financial years also, for 2012-13…

Hi Cesar, I have created TIME hierarchy in RPD, alos having it in Presentation layer. But in BI answer I am unable to use Todate function. Time hierarchy is not coming in Edit Formula Box so unable add "time_level" for ToDate Function. as shown below... Please suggest... regards, Abinash

Hi Cesar, Thanks for your reply. I created the "Total" column in DIM_TIME table. but m confused how can a dummy column will help me to solve this. With which column I have to map the "Total" column in RPD. And Also while using Time series function, Heirarchy details are not coming in the Edit Formula box, so i am unable to…

Hi Joel, I went through your link and also some oracle docs for Time Series Functions. I found ToDate function is used to calculate the running sum till current date which does not apply for my case. For me, the data(sales amount) is already in cumulative nature.So if I apply ToDate function, it will again add up all the…

Hi Joel, Thanks for your update. I have time dimension hierarchy set up as shown below... Where should I use the ToDate function, In RPD or in BI answer? And how to relate Prompt values to this Function?@Joe Fin