I would like to exclude from the results of each customer_id the one product_id that was entered in the dashboard prompt. ?? If you have customer and product joined, why cant you simply apply filter on it to get the above result? why need a union? just drag and drop customer and product and keep prompt for those columns.…

Can you provide some sample scenario, so that we will have better clarity.

Hello, You can use java script to achieve the same. Create a script like below and keep it in your server Then go to agent advanced tab and use the script file there. Thanks Asim

if you remove aggregation rule, it will not only remove grand total it will remove the aggregation of result set. combine similar request is an obiee feature. It is nothing but UNION,UNION ALL, INTERSECT etc. If you are using DDR u can modify the query with union all

Use combine similar report and add the same criteria there and use the second criteria for grand total. For example try like below first criteria country userscount amount2 amount3 second criteria "Grand Total" 0 amount2 amount3

But where you are using the logged in user details in query to find the appropriate group?

Mostly it could be because of the presentation variable. For a number column in DB your report may be passing character values or comma seperated numbers.

Ok.. Add a Narrative view and include your columns like below @1 @2 @3 @4 thanks Aj

Did you check in any other browser?

Hello, Go to your column properties. Make Column heading Blank and check custom heading and make the font color as white and size as zero. Go to table properties and make the below change. Now export it as data and in the save window save it as file.txt . Thanks Aj

Better make it a dimension instead of fact. Ie create an alias and self join with the table and use it. It will work. As you dont need aggregation dimension will work. OR Make your amount column as a key in RPD. Still it wont aggregate. These are not direct solution as it is the default behavior of OBIEE. But if you really…

From Publisher, we can add CC in Schedules.

Dear abdul , As far as i know it is not possible in 10g ibot. But you can do it from 10g BIPublisher. Use the report query and schedule it using publisher and you can even use BCC. . Anyway it is an ibot and users may not need to use the dashboard features. OR Download the ibot using javascript and send it via Batch…

if both of the columns are from same presentatiion table , simply create the columns as the same in presentation variable or vice versa and apply formula like below topn(table.@{PV},10)

Dear Jerry, You have Category, Item , Expense and Budget tables. why cant you join like below Category to budget only category and item to expense table ideally you will have two facts with one non conformed dimension, which you can set total as its level for expense table OR Make it under one source in LTS and left outer…

Hello, Instead of having a text column for seggregating ytd1 and ytd 2. try like below Criteria 1 Billing Region Ytd 0 Biling region 0 YTD1 Thanks Asim

Create two seperate analysis one for pivot and another for chart and keep it in same dashboard page

As it clearly says, you need to contact your administrator or anybody who has access to logs

Keep two dashboard pages and make one hidden. Keep prompt in both the pages. and prompt level should be dashboard. Use javascript for navigation. I dont know if you can use other methods. Like Condition in Section and show the report after selecting the values from prompt. It will ideally satisfy the requirement. Or…

Did you check the column properties for interaction? Also check in a different browser