Haven't had time yet to look in to this further and there are more important issues now that I'm working on. I will mark this question as assumed answered for now.

Ah ok... I was confused if I missed something :-)

@Joel Acha , In what way differs your answer from the one that I already gave?

Like this: The errors are likely caused by the colon (:) in your path name. The tool doesn't seem to handle non alphanumeric characters correctly. I do not know how to solve this other than to remove the non alphanumeric characters from your path names, like : ; ( ) + - Edit: The best thing you can do now is probably…

@chillychin Did you manage to get the report that you wanted?

That is basically what the Include rows with nulls would have done for you yes. :-) Nice to hear you have solved your problem and I agree with Robert it's nice to get the acclaim for our effort.

Do you just need the name of the Analysis? This will get you a report with columns, Folder, Name, Path, Child Name where Child Name contains the Analysis name.

The question is a bit unclear but it appears you want all products (where pqr =1) to show up in your reports, also the ones that do not have metric values. Have you tried to use "Include Null Values" in your report? Or for a cross tab report: Hope this helps

Seems like you forgot to add the columns you want to report on for Children In the "Children Columns in Report" section. That should give you the report that you want.

Not by using a union query. What are your models like? You need a conformed Invoice dimension because that is what you need join the 2 data sources on. Please provide details on your data model so we can give some more detailed advise.

Well, of course you will see two rows, one with order type NULL, the other with order type "ITA 1001 Order" (exactly as in the table you are showing). But maybe I do not understand your issue? You need to conform the Invoice dimension to be able to properly join these facts together.

Thanks, I will look into that. Will update on this but it make take me a few days.

Thanks Gianni, I already checked this and unfortunately S_NQ_JOB_PARAM doesn't include the Dashboard Or Analysis name and/or path. That information seems indeed to be only available from the agent XML.

At least we gave the same advice ;-)

If you want to use Prompts on the translated you should create a description column with the case statement in the repository so you can use a column prompt on that.

You should prefarably not solve this in OBIEE Answers reports , especially if you need this in more then one report. You should best create some description/translation column or lookup tables in your database. See: https://www.rittmanmead.com/blog/2010/08/oracle-bi-ee-11g-lookup-tables-sparse-and-dense-lookups/ The dirty…

(Why) Does it need to be a single prompt? You can Limit prompts based on values from other prompts:

We have created shared 'Agent User' accounts for that as a workaround. 

Well, in my opinion having to join to facts together, even if they are 1:1 generally means you have to reconsider your model design, but from a technically point of view you are correct.

What is your model like? If you have joined the facts directly then you will not get the results you want. Facts should be joined by Conformed Dimensions. Create a common dimension(s) between the two facts and you will be fine.