Text can't be aggregated (well, technically some aggregation functions works on varchar, but you will not get what you expect). To concatenate multiple rows into a single one you should push down the job to the database using EVALUATE (or one of the variants of this function). If you do use an Oracle Database you can then…

What else you can do? Well, not trying to be rude or anything, but stay on the other forum to get support on a generic cloud account issue. This category is for OAC and OAS, and your question isn't related to Oracle Analytics.

Sounds like you found the other forum, where generic cloud questions should be covered: https://forums.oracle.com/ords/apexds/post/i-need-account-registration-support-4966

I would say that right now you can't do it directly, not as easy as "classic" can do it. The workaround would be to make your union in a dataset. Just be fully aware of the possible issues and downsides of having a dataset just for a union. There is an idea you can upvote to add that feature:…

Are you asking about an Oracle Cloud account in general? This is the forum for Oracle Analytics, if your question is generic about Oracle Cloud, you are in the wrong place. Oracle Cloud has it's own support channels and you should stick to that (a public community forum can't do much to help you in creating for an account…

@David Wright - More4apps , You better start a new question where you expose your issue (and provide product names and versions). This is an almost 6 years old abandoned thread. Also, look at the categories and pick the best matching one (there is one for Publisher).

Do you want to move 1-to-1? No upgrade planned anywhere? Because many (most?) of these versions are extremely old and probably not supported anymore. And moving environments is a different process than upgrading on a different environment.

Hi, What do you think the "publish event" does or should do? Because you probably expect something it isn't meant for... The Publish Event enables external applications to receive the set of data element values in the selected visualization, known as the visualization context. This is from the doc, but the doc is titled:…

I wouldn't call it "data breach", because it's obvious that it can be done if you allow direct access to your database. It's like if I give you the keys of my home and tell you to freely go in when you want and use the kitchen. Then I will start questioning if I should call the police on you because you could also go in my…

A Publisher datamodel / connection isn't a valid source in DV. For 2., no idea what WebCenter is and how you access it: DV can access files in various places in a number of ways, but still doesn't support every existing source.

Hi, Are you really going to use OAC and not OAS? In OAC, as far as I know, IDCS is the only security provider available. This means that if you want any form of SSO you should also use the cloud IDCS in your EBS. This seems to be doable (at least for some versions / configs). But it's probably not what you have... I'm sure…

And, as a side note: your forum username/display name should also mention "-Oracle" to show that you are an employee.

Hi @User_6ITQ2 , As this thread was quite specific on the OP problem, you can maybe create a new question where you provide all the info describing your context and what you tried that didn't work so far etc. (also including a product name and version helps).

You shouldn't care about grouping rows, because that's what the product does by default as soon as you do select a measure. I finally got my hands on an environment to do a quick test: selection steps works but are generally used for operations on the dimensions. In your case the filter on the measure should work... The…

Aren't you facing a pre-aggregation vs post-aggregation filtering? If you filter before grouping rows, your measure counting the transaction is probably 1 because each transaction is an individual row. While after grouping your rows based on your query, your measure counting now has a value based on the number of…

Ezequiel is assuming that you have a database. The EVALUATE function is pointless if there isn’t a backend to push down the formula to, while your own time dimension is just a join away (on the date) from any source you are using. Also a detail: the Oracle database can give you back about 3 if not more weeks calculated…

For any time analysis like this one, you should provide your own weeks, because every company has different meaning of something as subjective as the week. You should have a time dimension containing all the required information based on your own definition of what the weeks should be like. If you do want to dynamically…

There are different policies needed in OAS that didn't exist in OBIEE. Depending how you did move the content over in your upgrade, if you took with you the security model (application roles), you probably did override the default OAS application role with the one from OBIEE, and you lost the application policies that were…

Hi, With errors involving .cpp files, there generally isn't much that can be debugged... Did you apply all the available patches for your environment? Did you search in My Oracle Support (https://support.oracle.com/) for something similar?

Aren't you using the wrong tool for the job? OBIEE first, and OAS now, has never been designed to be a database, to store data, and act as data source for analysis. The tool was meant as gateway to connect various sources together, model them to give them a business meaning, generate dynamic queries, and let business users…