Hi @Chandra kanth As long as you have a properly modelled time dimension and hierarchy, you should be able to achieve this using the AGO function and the Week level of your time dimension.

Something similar to SUM(CASE WHEN COUNT(address BY address,sales agent) > 1 THEN 1 ELSE 0 END BY sales agent) should do the trick. Sent from my iPhone

You'll probably be able to debug the source of this using F12 browser developer tools. As Christian mentioned, this is more than likely a skin customisation issue.

Hi @user12863665 A workaround would be to "trick" OBIEE into thinking that the colum is different in the detail report by appending a space to the end of the column for example. You'll need to do this in both the column and its prompt on the detailed report.

I Think all that needs to be said about this has already been said. The BI Server is only as clever as the repository model in a nutshell. If properly modelled, all underlying database performance indexes, partitions, hints etc. will be utilised in query generated by BI Server. You'll have mo other option but to redesign…

To use this in your report, you'll need to have your Fiscal Date Hierarchy exposed in the Presentation Layer so that you can reference the Fiscal Year level in the TODATE function. An example of it usage can be found here. Alternatively, you can create a YTD column in the BMM layer and directly reference the hierarchy in…

Hi @Abinash2707 If you have a Fiscal Year date hierarchy setup (which in your case runs from April to March) in your repository, then you can use this alongside the TODATE time series function to achieve this.

Hi @3174977 a quick Google indicates that this (apps.fnd_global) is an Oracle Ebusiness suite package. This could mean a couple of things: * The package is in an invalid state and not compiled. * The user setup in the OBIEE connection pool doesn't have the execute privilege on the package * There could be a missing synonym…

HI @vai, this is probably because under the General tab, your agent is set to run as Recipient. Change this to run as a specified user and you should get that option in the Recipients tab. if you set it to run as recipient and the recipient is just an email address then OBIEE has no clue what to do so the option is…

Hi You could modify Paul McGarrick's "Export to file system" solution You can use a VB Script to set the file name.

In that case, @Mark T., you could possibly achieve this by enclosing the logic above in a TO_DATETIME function.

Hi Mark T If your data source is Oracle, you could use the EVALUATE function and use something similar to this to achieve your requirment.

There is a client installation available on the website just under Oracle Business Intelligence Developer Client Tool (12.2.1.0.0) This gives you the OBIEE client tools that I think you're after. A Similar section exists under the 11g section if that's what you're after.

I think Christian's point is that reading manuals isn't the right way to go about your certification. Training Courses are helpful but it's getting your hands dirty daily whilst using the tool which is definitely the better approach. Sent from my iPhone

PRobably best to move this to the forum.

Check this Oracle blog article.

That looks like your problem then. Could you try replacing the analytics with analytics-ws in your config for the OBIEE URL and see if this makes any difference?

Can you execute the URLs (the text that you have hidden with the purple lines in your screenshot) manually that have been generated by the BVT? Try running as the same user configured in the BVT config file from a browser

Not exactly but the closest you'll probably get is to use the UI plugin to look at screenshots of executed reports and you may be able to pick out visual differences

OBIEE is the wrong tool for this requirement. You won't get good performance and the ability to visualize this volume of data. OBIEE is just not designed to do this.