nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to show a custom data when there aren't datas

Barticchia

Hi to everyone

i got a problem with an analysis.

I'm going to make an example as easy as possibile:

i have 3 fields; the first one is prompted.

Normaly, when there aren't datas for field prompted, a message appear like:

No Results.

The specified criteria didn't result in any data... something like that.

Question is: Is it possible in that case showing all 3 fields with 1 1 1?

field 1 field 2 field 3

1 1 1

Source where i get datas is a view.

Any idea?

Many thanks

Find more posts tagged with

Accepted answers

All comments

ArijitC

You can use custom mesg for no data...

[Deleted User]

Hi Barticchia,

Having fun late at night? So if your query actually does not retrieve anything at all from the data source it's hard to "fake" a row because the data set coming back is - well - empty.

What's the use case and hwo does it help you to to have a fake row of 1s?

Barticchia

You right Christian! this is the best moment to work without noise around me (my wife )

Anyway...

This issue because all project is using web services request and they use XML query.

Results looks like

<Row>

<Column2>INFOSTRADA</Column2>

</Row>

when no recors result, MUST be like

<Row>

</Row>

It means that i have to custom result with some kind of dummy record.

let's leave aside webservices for the moment. If i can solve it here in analysis, will be solved even with WS.

Any idea Chris?

Barticchia

thanks for your answer, but this will not suit to the request.

Sherry George

Have not tested this idea, may be create a union report ?

[Deleted User]

Sherry beat me to it. A UNION would be a way to force this.

Then again you said the data source itself is a view so maybe the code in the source could already deliver you that default row. This way your front-end can be built without having to handle that exception case.