Drag RANK to "vary color by(horizontal Axis)" section before Product_name. Then hide RANK from column properties in criteria section. If you need to group by "RANK" then duplicate that column and use it in both group by section and color by section. You are using it in color by section with hide option just to force it to…

If you change your instanceconfig.xml file and set <SupportAutoComplete>true</SupportAutoComplete> under <Prompts> section then it will help you to suggest auto complete. Also you can use prompt to limit values of other prompt. Thanks Arijit

I think I was wrong. It does take from default value and then does not refresh subsequently. Thanks Arijit

Yes, this is possible. Here is how you can do it. Use presentation variable pv_start date in start date ..then user that in second end_date … SELECT TIMESTAMPADD(SQL_TSI_DAY,7,"Usage Tracking"."Time"."Start Date") s_1 FROM "Usage Tracking"

Increase canvas height, that might solve your issue. for example when canvas in my case is 200 px then I have this ... When I increase to 400 I get this ..

Can you edit the graph and show your Layout please. Thanks Arijit

In vertical bar chart, Horizontal Axis is always sorted by what you have in horizontal axis. No matter if it is a direct connection or not. I have not found anything in the property file to change this inherent property. I have overcome this issue different way. I have duplicated the measure column and converted it to…

You need usage tracking ... https://docs.oracle.com/middleware/1221/biee/BIESG/usage_track.htm#BIESG211 Rittmanmead has lots of articles on this ... https://www.rittmanmead.com/blog/tag/usage-tracking/ Thanks Arijit

One option could be using Table Prompt instead of Dashboard Prompt. Thanks Arijit

I verified and sorry my version is 12.2.1.2 not 3. I think you may need to talk to Oracle support if same connection works for 12.2.1.2.

One more change you need to do in connection property to bypass SSO..

I have same version and :USER and :PASSWORD works fine. Having said that we don't have SSO. Try to login in essbase from EAS with the same user. see if the user has all required essbase access. You can also test this in your RPD.... right click on dimension ...and select view members. select your connection pool and hit…

This morning when I saw this problem, I found it interesting and tried to resolve it. I came up with this Idea is to use oracle to_date query to resolve this select to_char(to_date('2017-02-01 11:59:59 pm', 'YYYY-MM-DD HH:MI:SS pm') + 2/24, 'YYYY-MM-DD HH:MI:SS am') from dual; where 2 of 2/24 is the offset value, used as…

Thanks for sharing the blog. This is good.

I don't think you can change it. This is how export to excel works. You can check oracle documentation here

Edit the column formula. Check what Aggregation rule you have in 12c.Can you try by setting Aggregation Rule to SUM?

The 2nd graph you have problem with , should have pv_1 and pv_2 presentation variable filter in it. not a regular column filter. That should solve your graph problem. You can not do an automatic selection for 2 different table like that . The other option you have is really a Graph prompt or Table prompt. In a dashboard…

Here is how I replicated it …. I have 2 tables cost center and cost center Attribute. Both of them has column member_name which has very identical data. I have dashboard prompt member_name1 and member_name2. When nothing is selected both prompt will show full value list. If I select any one of the prompt then the other…

Sorry,I have to step out now. I will try to replicate it in my environment tonight, and reply to you. Thanks Arijit

I just wanted to give you an idea and what I wrote was not syntactically correct. It should be for Prompt 1. SELECT "Cognos_TurnoverByMonthOrgLevel1"."OrgLevel1Code" FROM "Ultimate" WHERE "Cognos_TurnoverByMonthOrgLevel1"."OrgLevel1Code" in (SELECT "Cognos_TurnoverByYearOrgLevel1"."OrgLevel1Code" FROM "Ultimate" WHERE…