A good way to test out your query for SQL Results in a prompt is to make a New Analysis from Simple Logical SQL. The prompt dialogues don't give you any error messages – they just return no results, but the Analysis page will show you the error that's returned from the BI Server.

Is the table view displaying the results correctly? When you say "I am trying to create the Graph on the same it is not working" what does not working mean?

If your BI_Server is not running then that's definitely the first problem to solve. When you say it can't be started, how are you trying to start it? (from the Weblogic console?) What get's logged when you try to start it? The log is in user_projects/domains/bifoundation_domain/servers/bi_server1/logs/bi_server1.log

In which case there's also a "page size" option on the dashboard properties. Setting that to Fit Content rather than Fill Browser Window will usually prevent things from getting spaced out too much without having to manually set the width of any elements.

because of that i ma not able to do this calculation soon report level. RPD level also i cant able to do. Why not? What happens when you try? The levels of the facts shouldn't matter – if you have them both displaying in an Analysis I can't think why you wouldn't be able to do a calculation between them.

Are there any other views in the compound layout of your Analysis? Are there any other objects on the dashboard?

Have a look at Doc ID 2131220.1. The location your custom EAR needs to be deployed to is actually ORACLE_HOME/user_projects/domains/bi/bidata/components/OBIPS/bicustom.ear

Is there a better way to do it? Definitely – fix the dimension. Alternatively (I'm not sure if this would work, it's normally done the other way around where the dimension should be shown when there is no fact value for it and I can't get my head around it right now) you might be able to try something along these lines,…