Do you have full permissions on the folder structure, have permissions been changed?

Do you have common dimensionality/attributes between the SAs Have you tried bringing in a measure and the common atributes into the criteria?

Do you have the option of bringing in your own data storing the dates of the holidays that you can then join to the query to exclude any dates in that dataset?

Are you talking about the layout editor for Word and Excel? BI Publisher comes with OTBI/OBIEE/OAS/OAC there is no install requirement for that in addition to the main install of whichever version of BI you have. The layout editor needs admin permissions and Java 8

You probably need to dip into some SQL such as the following https://blogs.oracle.com/sql/post/how-to-convert-rows-to-columns-and-back-again-with-sql-aka-pivot-and-unpivot

Why do you want a SQL statement can't you just alter the column format? otherwise use SELECT ROUND(<year>, 0)

Are you looking to use a fairly complex expression or just create a percentage for example

I believe the rule for joining any subject areas are Use common dimension fields Include a measure from both subject areas You don't have to use these in any of your tables or charts just in the criteria

have you tried create table as (1st select) then insert into table (2nd select), may give you better error messages

Have you tried the other way around converting the number to varchar cast as char. As you suspect likely to be a character type mismatch.

Hi you can't do this from the admin tool, you can do this from the BI Answers front end create a report with no filters and use the export function there Richard

You can hook up your static data in the RPD as a source, so long as you have a common field e.g Person# then you can create a filter analysis using this static data as if the data were part of the larger data set Richard

I believe that this is a known product limitation

You should be able to use the SQL option to generate the complete list. for ease of syntax just create a new analysis using the dimension column that you want to filter on and grab the logical SQL from the advanced tab

Do you mean side by side ? 1) Request that these fields are created as separate columns in the RPD then drag and drop them side by side as usual 2) Create a UNION with generic email plus a hard coded column with email type of "PERSONAL" ,"WORK" then pivot on the email type column

What aggregation rule ? You can set aggregation on the report column that will differ from the aggregation on the column in the RPD you can use aggregate functions SUM, MAX, MIN etc you can create aggregate tables to speed up report times ? Richard

Can you provide more detail, I'm unsure what you're after Richard Neodata Australia

Have you looked at this blog https://shivabizint.wordpress.com/tag/rpd-column-usage-in-reports/ Richard Neodata Australia

or if you want the previous month timestampadd(sql_tsi_month,-1,current_date) if you want to take into account the variable number of days in a month

Would this work for "My Dashboard"? I think this is unique for each user, you may have to go into each users folder via catalog manager and set this up?