probably need to preprocess that column, can use unix sed for example

Check that you are not truncating and reloading your Dimensions if you are using a sequence to populate your WID then you will be out of synch, use an insert/update strategy

Check that you are not truncating and reloading your Dimensions if you are using a sequence to populate your WID then you will be out of synch, use an insert/update strategy

This is tricky I want to do the same in GCP, ideally I want to access REST APIS from OAC linking to BigQuery as a datasource I don't think multi-cloud is a strong point

Thanks will look into this

Are you truncating and reloading. If this is the case you will be resetting the Dimension ROW_WIDS and these will be out of sync with your fact. You should be using an update/insert strategy for your dimensions

Have you tried creating a calculated field in the criteria with the difference between the two dates, you should then be able to plot this measure Richard

How do you want the hours to be rounded i.e. should 2 hours 45 minutes be in the 2 or 3 hour column should 2 hours 15 minutes be in the 2 or 3 hour column e.g. CAST(FLOOR(<minute column>/60 ) AS VARCHAR(4)) will give you the lowest full hour, replacing with ceiling will give you the next full hour truncate(121/60,0 ) will…

Maybe you need to split your chart into two that display the top half and the other chart that displays the bottom half, sort by rank and then filter ? Richard Chan Neodata Australia

Use a pivot table and put your "title" field in the section space Richard Chan Neodata Australia

You can also use ABS and 0 - measure in the column formula Richard Chan Neodata Australia Sent from my iPhone

What version of OBIEE are you using ? Richard Chan Neodata Australia

I think there are known issues with the PDF generator, it is possible to use other ones OBIEE 11g’s workaround for Bug 14472552: Print to PDF functionality doesn’t work properly « eeblog.org Richard Chan Neodata Australia

Try reporting on one column at a time to see when the error occurs. Are you familiar with the RPD ? If so you can trace back the offending column to see how it has been configured Richard Chan Neodata Australia

Why can't you run the same report in each environment (OBIEE PROD, OBIEE TEST) ? Two users is a good idea with separate DSN connections one to PROD one to UAT I'm not sure if this will work but you could declare these as a REQUEST/SESSION variable and have a dropdown prompt on the dashboard that allows the selection of the…

Can you ping test-bi01 telnet to test-bi01 9500 ? This will test the network connectivity Richard Chan Neodata Australia

Are you running on a cluster ? To check on the permissions for Answers click on the Advanced Link at the top right then Security - Manage Privileges then look at what has been set up for Access - Access to Answers, by default I believe this should only be set to BI Administrator Role and BI Author Role If you want to see…

So do you mean that you want a URL to appear on the header of every report that you create without having to manually go in and add it every time ? Richard Chan Neodata Australia

Can you please be a bit more specific about what you mean by basing the sort order on another report column, can't you just duplicate the sort order, alpha ascending etc ? Richard Chan Neodata Australia

When you create the prompt select the option to load the value into a presentation variable, near the bottom I think, then use this variable to populate the default in the other prompt and also use in reports. Richard Chan Neodata Australia