Jerry, You're DA MAN!!! Just one correction to the proposed formula: Using: 100*SUM(Workers by Region, Month, Age Bucket and Gender)/SUM(Workers by Month) calculates same percentage in all rows. After small correction: 100 * Workers / SUM (Workers by Month) calculates as required. Many thanx!

Well, you have already pasted the same link. And yes, I have repeated same setup. Error as in previous post.

Hi, I have added sort order and descriptor which were missing. Now errors are different: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000) State: HY000. Code: 43119. [nQSError: 43119]…

"Smart-ass" talk again... But what can do if there is no any measures to create, and all data are loaded into single table? Really worth to spend time spliting this into separate tables? Don't think so. It's not best practice, it's problem solving. Links describing similar approach:…

Well, no one provided any solution or even a suggestion. Instead I received question about version and some "smart-ass" talk going nowhere. In my opinion version has nothing to do with RPD setup, as it didn't change with newest version. Hint for solution: keep in mind that there is CASE formula, so you do not need to…

Providing easy to implement solution: in physical layer create dummy physical table with one column (can be named KEY), create a key on this column. Create complex join between your table and dummy table with expression: 1=1 Move to BMM layer all required columns from standard table and as new logical table key column from…

If anyone will be interested can contact with me and I will try to provide a description what I have done.

Issue solved. Thank you for your help and support.

Is version anyhow related to the described error or possible solution?

system.schema_version_registry table or view doesn't exist

Sorry, I haven't mentioned that this formula is is RPD. Thought that will be clear as I have mentioned about BMM placement ;(

@Sagar Tippe, Here are the findings. I have recreated the report by removing column selectors. Report contains 6 measures and is created as pivot table. On first column there was Total applied. First I have tried to receive error. When I have changed order of dimensions (country with region) I get error. When I have turned…

Robert Angel wrote:Yes, if you have the unmapped columns in your report at the level of detail that they are unmapped then it will error.Check also that you content levels are set correctly on the FACT / Dimension LTS. But once again Robert, why it works if I will choose Work Address County on first and Work Address Region…

Do you mean here? I have checked all of them. They are hierarchies, but any of them contains Region in levels or details. Region is only in Location Hierarchy, and in Country level. And I'm wondering if this can be an issue.

Hi Robert, Could it be for example that Hierarchy for Location is defined that way that Country and Region are on the same level? Honestly saying, even if we have different LTS used, measures are defined from single LTS. But to be sure, is there any fast way to check such duplicates?

I have stuck at the beginning of the process First free space error. When I have updated command setting tmp folder in it, I have fugired out that I have only Java JRE and I need to have Java JDK. So now, trying to install it EDIT: I have succesfully installed new Fusion Middleware 12.2.1.3. How can I login to it? Should I…

Hi, We are using OBIEE. There is no BI Apps

Release Version: Oracle Business Intelligence 12.2.1.2.0 All browsers, only in PROD env. Funny thing is that it's not always same graphs which are not displayed. Windows 7, Windows 10. IE, Edge, Mozilla.

Has anyone checked if one of the patches can solve the problem with not displayed graphs? I guess silence in topic means that no one else experienced same issue.

Finally I have found a reason why it was not working in filter. As there was CAST to char (3), it was adding spaces at the end, and it this case there was no such values. Adding TRIM solved the problem.