Hi, I think that you can use repository variable in this situation. In title try use something like that: @{biServer.variables['rpd_variable_name']} For current day you can use: @{biServer.variables['CURRENT_DAY']} But I think that for PREVIOUS_DAY you must create rpd_variable manualy. Create Initilization Block for…

It doesn't work? Maybe, can you write something more? What doesn't wokr? Some error? I use this option in a single analysis and working properly on 11.1.1.7.131017 Short description: BI Direct: OBIEE 11g Release 11.1.1.7 – Navigation from the Total or Grand Total in a Table or Pivot Table View

Hi, I have the same problem when I created manualy SUM for columns. I don't remember which version it has been entered, but you can automatically turn on the drill for a grand total:

Hi, If you don't have a lot of reports for publication, you can apply for example Action Link Menu on your dashboard. And when you add Action Links / Naigate do BI Content / You analysis/report etc. in option check Open in New Window.In Action Link Menu Properties with Menu Label and Caption you can create some tree with…

Thanks for reponse, I know this is a little strange problem, but don't know what people come up with.I'll try to implement your suggestions. BR

Hi, You asked in the wrong topic. Ask here:

Hi, I think that one way to do this is create column 100 - Null percent (in %) like you said beacause Pie Chart in obiee does not have the possibility of a global scope settings as 100%. Why do not you want to use such a solution? .

Actually it works, I had somewhere to make a small mistake. Thanks for the help.

No. I create dashboard prompt, something like that: I use SQL formule: SELECT "Supplier"."Supplier Name" FROM "Procurement and Spend - Purchase Orders" WHERE "Supplier"."Supplier Name" NOT LIKE 'Supplier Name' FETCH FIRST 65001 ROWS ONLY And when I test it on prompt and I search this supplier: This position is further up…

Thanks for response it's clear for me but I must test it. The best option for me would be the exclusion of these suppliers with prompts, which applies to the second point. Someone may know that the SQL does not work or how you can not exclude that items on the list instead choose those Someone may be available?

Christian thanks for response, Ok, that I can add dashboard prompt. In prompt can I use something like that when I want exclude one supplier from analysis? I have another question about my second point. Is this option has no effect on the values in the prompts?

Hi, I think that you could display null value and then count should be working ok.

Hi, Yes, you could use presentation variable for this. What error do you get? Please description. More info: http://gerardnico.com/wiki/dat/obiee/presentation_variable_use Or you can use for example column selector when you choose between male/female colummn. It depends how you hold data for male/female? Do you have two…

Hi, Yes we can move Report Links to the other position. Please read: http://obiee10grevisited.blogspot.com/2012/06/moving-report-links.html OBIEE: Report Links on top of the Report

Read about Time Seriec Functions: OBIEE - Time Series Conversion Functions : AGO and TODATE [Gerardnico]

Abinash2707, In your screen with TODATE formule If you want to add TIME LEVEL you shoud write something like that: "TIME"."AD_DIM_TIMEDim"."Fiscal Year" Your complete formule: TODATE("INDSUMM FYTD"."Sales UTI", "TIME"."AD_DIM_TIMEDim"."Fiscal Year")

Ok, it's working.

Hi, Where you want to show them? In analysis? In table/graph? I do not know how it is in version 10g, but maybe for example in Analysis Properties/Data is Include Null Values. Or in table properties is Include rows with only Null values.

Hi, This formula is a bit of a misnomer, because if you use CASE WHEN for measure column, it must be the same type of output, and IN THIS case is 'Do Not Consider' and measure column. You can use something like that: CASE WHEN "Fact"."MeasureColumn" > 100 THEN 'Do Not Consider' ELSE 'OK' END You can't use: CASE WHEN…

Refresh — Use this option to refresh the results of analyses included in the dashboard page.