Asim, Your suggestion (If I understand correctly) will refresh the webpage which is different from an actual refresh using the refresh option: In Obiee12c Dashboard refresh forces Obiee to requery data from the database and caching will not be used.

If the aggregation rule of your column formula is set to Server Complex Aggregate then OBIEE will do a REPORT_AGGREGATE.

Thanks for the clarification Gianni, that may well have been in the logs but I never saw it because I realized what was going pretty much directly. After correcting the query everything refreshed properly again.

The Query had become Invalid. So the IB could not complete (Because of an ORA message).

Do you have multiple Ini Blocks? I had an Issue with Rep variables that did not update and the cause was actually another Ini Block that failed thus preventing all other blocks behind it from completing. Make sure all of your Ini Blocks are valid. You might have already ruled that out but I wanted to share anyway.

I don't think you understand the solution. Grouping by Month is exactly what you want, that's what you are reporting right? Totals by month... Follow these steps and you'll get just that: Physical Layer - Map TY weeks to LY in your period dimension (Alter table) - Join Fact to TY week in period dimension - Join Alias LY…

How can the Primary key be at Year Month if the data is stored at week level?

Your period dimension should be like this if you want to use thomas' approach: Year Month WeekNr WeekNr_LY 2012 01 201201 201101 2012 01 201202 201102 2012 01 201203 201103 2012 01 201204 201104 2012 02 201205 201105 ... 2013 01 201301 201201 2013 01 201302 201202 2013 01 201303 201203 2013 01 201304 201204 2013 01 201305…

To be honest, you could have told him the your (perfectly valid) argument in a more friendly way, we're here to help each other, not to to make others feel stupid. I'm here answering questions to help others and as a result get better myself, so I welcome criticism, but be fair.

@2791486 Happy to help. If you found my answer to be helpful or correct can you please mark it as such?

If your data is stored per date: TIMESTAMPADD(SQL_TSI_DAY,(DAYOFWEEK(CURRENT_DATE)*-1)+7 ,CURRENT_DATE) CURRENT_DATE should be replaced with the date in your date/time dimension.

Not trying to be Mr Obvious here, but you have checked the schema user and/or role permissions right?

What column are you using as a sequence and what does this column contain? Are you sure it is really sequential? That is, you can get the leading value simply by adding 1 to that value. 11 + 1 =12 2016 + 1 = 2017 But: 201612 + 1 <> 201701

The Catalog is not one single very large XML file, Its consists of User Folders and Shared folders in which every object (Answer report, dashboard Page etc) is a seperate XML File. The Search/Replace Technic using the catalog manager as described above is very useful, I have used it often to quickly create reports that are…

As Christian already stated, this cannot be done like this in OBIEE, the design isn't correct. It seems you want to provide the user with the details so they can validate the figures that are in the attributes section. (In my opinion) Properly designed dashboards show only high level data which can be drilled down to see…

I suppose I should have searched the forum first because this has already been answerred: . This describes to rewrite the query using a outer join. Still, I think a NOT EXIST makes more sence semantically so I would prefer to use that approach if possible.

Thanks Christian, I have looked into that but I think that way you will be able to do NOT IN subqueries but I don't see how to do NOT EXIST from there.

You may achieve this by using presentation variables as described here: https://myobieespace.wordpress.com/tag/cascading-prompts/ However I think there maybe some issues with this, like it requires you to hit apply before the dependent prompt will refresh if I remember correctly HOWEVER...You should first look on how to…

You can override the logical sql used by selecting 'SQL results' for Choice list values: Is that what you are looking for? EDIT: also, the physical sql issued by the prompt will show in your session log with type ValuePrompt, or you can issue the logical sql yourself on the administration tab to get physical sql.

Well, I would strongly advise you to read https://docs.oracle.com/cd/E23943_01/bi.1111/e10540/toc.htm because you shouldn't mess with the Obiee Repository unless you know what you're doing obviously. Chapter 19 deals with variables.