No results messeage — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

No results messeage

Received Response
71
Views
8
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead
edited Aug 13, 2024 5:40PM in Oracle Analytics Cloud and Server

Hi I am using  OBIEE 12.2.1.2.0

When my analysisi results in no data i get the following message ''The layout of this view combined  with the data, selections,drills or prompt values resulted in no data.''

However i want to put custom message instead of this one, i go to analysis and i do this

pastedImage_2.png

but it still gives me the same message.

I realized that it ignores my custom message when i tick this option : Include columns with only Null values

pastedImage_3.png

When this is unticked it works fine, but i need that option.

Is there a workaround for this, or maybe something that i am not aware of??

Thx, Matija

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    The 2 options are mutually exclusive. Either you display your custom message and don't display columns only with NULLs or you don't display your custom message and display columns only with NULLs.

    You simply can't do both.

  • mmajdana1
    mmajdana1 Rank 6 - Analytics Lead

    @Joel Acha  If i tick this option when i have analysis it look like this

                                     Store1          Store 2             Store 3

    Shampoo                     1                                            3

    when it is unticked it looks like this

                                    Store1               Store 3

    Shampoo                     1                        3

    So the requirement is  that analysis must show all stores regardles of units sold

    But when no results ocuurs ( which means that there are not any units sold for any store)  i should have my custom message

    Why are this two options mutually exclusive, they should not be...

  • mmajdana1
    mmajdana1 Rank 6 - Analytics Lead

    Especcialy considered the fact that it showes me the no results message, but not the one I want.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    The "No Results" message and "the layout of this view" are two completely different things!

    The first one means that the data set coming back from the OBIS is empty. I.e.: There *IS* no data.

    The second one means that you did some post-data-grabbing operation in the display and visualization of the data so that none is left - the data stream itself contains data though.

    So maybe take a step back to thing of what you're trying to do and bear this distinction in mind.

  • mmajdana1
    mmajdana1 Rank 6 - Analytics Lead

    @Christian Berg

    First of all thank you for all the effort you do,and not just about this issue.

    You clarified me the distinction between no results and "the layout of this view", so if you read my second post in this topic you can see what is the only difference.

    When ''Include columns with only Null values'' is unticked it gives me no results messeage, but when it is ticked it gives me ''layout of this view...  ''

    So, according to you only post grabbing operation is including the columns that have no values, so I am now a bit confused because there is no restriction after grabbing, and it is clear that  dataset indeed comes back as empty from the OBIS otherwise it would not show me the no results message when the option is unticked.

  • KBabu
    KBabu Rank 3 - Community Apprentice

    Hi mmajdana

    Christian, Rob,Srini & Joel are experts in providing solutions for any issue (If you are able to explain your issue and desired output to show it to users).

    The current situation in your OBIEE:

                                         Store1          Store 2             Store 3

    Shampoo                       1                                                3

    Your expectation in OBIEE:

                                         Store1                                             Store 2                                                                                    Store 3

    Shampoo                       1                 Sorry, No values for Store 2 (custom Message)                                                        3

    Is my understanding is correct ?

  • Saresh-Oracle
    Saresh-Oracle Rank 5 - Community Champion

    You can try to change it in viewmessages.xml ?

    Thanks,

    Sareesh

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Kabu,

    Then ALL of his presented data has to be text/varchar ...