try @{system.currentTime}

To have access to the RPD and Admin Tool ? If so you can generate a csv report that you can view in Excel Tools -> Utilities then select Repository Documentation Richard (Neodata Australia)

Hi, I tried replying to this earlier but looks like it didn't go through Excel, PDF etc exports use the view to export the data CSV export uses the criteria to export the data So hiding , excluding columns in a view will work for Excel, PDF exports but will not affect csv exports, you will need to restrict the number of…

You may have a conflicting rule somewhere or the data doesn't actually pass the check, do you have spaces instead of NULLs for example, I agree with Prudence, putting personally identifiable data out in thge public domain is a big no no and you are potentially open to legal issues, sanitise your data first

Upper(left(string,1))||lower(subst(string,2,length(string)-1) or something similar not sure of exact syntax but you get the idea

What is the physical SQL produced ? Get this from the session log. Try just the two measures then bring in columns and filters one at a time until it breaks there maybe a missing join or level in your rpd

Apologies the doc is restricted but looks like http port 80 https port 22, 443

I have a diagram at home, I'll post this up tonight

How are you joining these two pieces of information together are they stored in separate facts with conformed dimensions ? Can you check the physical query that is being generated through the Administration - Manage Sessions and look at the log

What message are you getting with CURRENT_DATE - 1 ? and yes TIMESTAMPADD is your other option

It's a manual client based tool from my experience, ODI may be a better option for a full production automated environment

It's for for both OAC (Oracle Analyics Cloud) and BICS

It is because a user is duplicated somewhere, possibly they have had more than one role, maybe select the role with the maximum effective date i.e. the most recent role ?

Have you looked at a B,I publisher solution 

Either specify the pivot view to display on the dashboard or alter the default compound view to replace the default table view in the analysis Richard

SYSDATE is CURRENT_DATE in OBIEE for your future reference

What is the data source, Siebel ?

Does this post help you http://appsconnect.custhelp.com/posts/542549cc72 Also consider setting up a master subject area that contains the content of both subject areas Subject Areas are there for a reason they set the boundary for the query set

This needs to be expanded beyond reliance on ODBC connectivity e.g. REST API connection

have you checked for any patches related to this issue?