SELECT SUM(x_paid_amt) S ,COUNT(x_paid_amt)C ,x_pymnt_handling_desc FROM fact_vchr_payment_type WHERE x_business_unit = '80801' AND P_BANK_ACCT_KEY = 'RFND' AND x_paid_amt <= 10.00 GROUP BY x_pymnt_handling_desc ORDER BY COUNT(x_paid_amt) ,SUM(x_paid_amt) 

Resolved: Re-boot of my PC

Cyrille That sounds like one way to do it. I have 7 report objets on my page so that would not be my first option unless it is my only option.

Not sure how to get filter onto canvas , see image

See thread "data sync question" We are already clearing via the Data-Sync ETL however, that does not fix the issue within DVD. Question; When you run "Refresh Data" within the project does that have the dataset call the ADW or does it just refresh with the local dataset? We need the local datasets that are set to cache to…

More info, My numbers did not change in my DVD reports. I did F5 (browser refresh), but they stayed on yesterday’s numbers. After Data-Sync ran I opened DVD and still saw the same numbers from yesterday so first I tried F-5. no luck I then went to the Data section of DVD and did a data update on my dataset. This should…

You have to first create a connection in Data Sync. Define a connection to OAC, with a user who has BI Data Modeler role. Choose type as Oracle (BICS). The url is your OAC url (without any extensions). Type in the usual user name and password, and test connection. Only connections of type 'Oracle (BICS)' can be picked for…

Will do. Thanks :-)

You have two options for this - go the OAC semantic layer (not just a manually created datasource), and create your datasource in the semantic layer (RPD). There you can manage cache refreshes with some set frequency. This requires using the Admintool to design RPD or - keep the source you have now, make it Live, not…

I have reached out to our Oracle connection and requested some help with this. So far no luck with Google. 

Wow over my head ;-( - go the OAC semantic layer (not just a manually created datasource), and create your datasource in the semantic layer (RPD). There you can manage cache refreshes with some set frequency. This requires using the Admintool to design RPD

We want to stay set on Auto Caching for performance reasons. Is there a way to Automate, to get the Datasets to call to the ADW each morning and refresh? 

 Analytics , they are talking about Analytics

Version: 105.3.0-100

This is the screen I get when I open My Service (see image). I can't find a version number. Odd. Yes I'll open an SR

Should it work like PL/SQL Top 10?

Bad screenshot on my part. We need less 10 or less "value<= 10.00" I did try the range. No error but the results were not right. Question where do I find the OAC version. All I can find is the ADW version.

REsolved by using the Aggregation Method BY function

If you ever get an answer I'd like to know too

It was caching, I guess, I closed the browser and re-opened and it started working. Crazy!