Hello, why dont you save the 30 suppliers as default values in prompt? or use saved customization for each user and send the dashboard as ibot as recepient, so that they will get their required data. Thanks Asim

For a quick fix you can use below. It is always better to configure at RPD level. for Previous quarter end date. timestampadd(SQL_TSI_MONTH,-3,Date '2017-03-31') for year start date Apply a filter for between clause and use the below with CURRENT_DATE for YTD timestampadd(SQL_TSI_DAY,(-DAYOFYEAR(Date '2017-03-31'))+1,Date…

Most of the people will not come back and close the thread once they get answers.

Just a doubt, cant he join it? with Col A of first table with column A of second table? Select table1.colB, table1.colC from Table 1 (SQL server db table) where table1.colA in (select table2.colA from table2 (Oracle database table)) something like below? select table1.colB, table1.colC from table1,table2 where…

Try 12c Visual analyzer where you can blend data from different data sources. Blending Data That You Added

Why cant you use an agent(ibot), if it is huge use javascript to download it to the path and provide access to business users , so that they can directly open the CSV.

Dear Set the logic for selected period in criteria 1 and total for selected period in second criteria and for 12 months in third criteria. Use union all and check if it works(Combine similar request feature) like below criteria1 column1 column 2 MonthName(Datecolumn) amount filter - Jan to March 2017 criteria 2 column1…

Day of year could be different in leap year. Include a case statement like below to validate if you are using day of year formula. case when (MOD(year(Dim_Date.DATE), 4)=0 and MOD(year(Dim_Date.DATE), 100)<>0 ) OR (MOD(year(Dim_Date.DATE), 4)=0 and MOD(year(Dim_Date.DATE), 100)=0 and MOD(year(Dim_Date.DATE), 400)=0)

timestampdiff(SQL_TSI_DAY,CURRENT_DATE,timestampadd(SQL_TSI_YEAR,(timestampdiff(SQL_TSI_YEAR,"Personal Information"."Last Hire Date",CURRENT_DATE)),"Personal Information"."Last Hire Date")) apply 0 to 30 filter. Thanks Aj

Cant you concatenate splitter in to the data set something like below? ColumnName||'|' and add enough space between splitter if needed. Column Name||' '||'|' Thanks Aj

With SA system it will actually configure a delivery profile for each user. You can try creating generic user groups in weblogic and assign Delivery lists to those groups and use session variable in dashboard prompt and run as recipient in ibots. Thanks Aj

Dear R K For the first issue, Simply set aggregation rule to None in Criteria Fx. Second issue can you elaborate with an example .. Confused. Thanks Aj

Download and explore the preinstalled sampleapp from oracle. Just you need to open it and use . As simple as it is .. http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html Thanks Aj

Dear Selva, Use Session Variables for DSN and User. There are lot of links in google to explain you better. I dont have access here to provide you the links. Thanks Aj

Dear Kavya, OBIEE just displaying the records like that for convenience. So your branch name is actually repeating as per query and the count is correct. I dont think it is possible to acheive the count in the way you mentioned. Try BIN concept if you have limited number of branches and it will not change in future. Thanks…

did you try a select statement from DDR window just to ensure that you have all permission to execute DDR

Try this syntax. call yourfunction(Parameters);

Check by keeping 2016 instead of pv in criteria and check if you have results for the year 2016. Also in advanced tab in Prefix keep SET VARIABLE LOGLEVEL=2,DISABLE_CACHE_HIT=1; and get the query from administration ->Manage Sessions and validate the query.

Dear Ram, The value we pass from dashboard prompt will be considered as a text and we need to convert it to date in column formula, For that you need 'Date' Function and which supports only the above syntax. .. May be @Christian Berg Or @gerardnico will be able to explain it further. Thanks Aj

Dear Ram, Your syntax seems to be the issue. Try like below Year(Date '@{P_Date}{2016-03-03}') Thanks Aj