User Profile
Portmone
Regular Visitor
Joined 5 years ago
User Widgets
Contributions
Re: Performance tuning Oracle ODAC driver with FetchSize option on OnPremises Data Gateway
That only did not try with acceleration of requests to Oracle. There is one report for 370+ million rows, the initial data loading can take about 4-5 hours. The server with the gateway and the server with Oracle are practically idle. RAM 120GB Processor for 64 cores. Network 10 gigibit. Actually loading all the same rests against something. The fetch size is 16777216. Moreover, both in Microsoft.Mashup.Container.NetFX45.exe and in the registry itself for odac. No one has found a way to speed up the selection and get a download of at least 200-300 megabits?Bug? Counting the value for the same number of days in the previous month.
Hello, everyone! I'm trying to calculate transactions for the same count of days for previous month. I have a great formula Transactions MoM = CALCULATE([Transactions], DATEADD(FILTER(DATESMTD('Calendar'[Calendar day]), 'Calendar'[Calendar day] < TODAY()),-1,MONTH)), but it's not working correctly on the last day of month (2021-08-31).... I get [Transactions] for full previous month (2021-07-01 - 2021-07-31), but expect [Transactions] for period from 01 to 30 day of month. How can I fix that? Correct amount which I expected is 9 642 542, but got 9 935 710.Flag column for detecting payment in category with other selected filters
Hello everyone! I already broke my brain with a simple task. I have transactions table with customer_id, service, transactions and dates. I need to make a calculated column that should display if a customer pay some service by selected filters and calculate count of a customers with flag Y or N (payed or not) Day 1 Day 2 Day 3 Day 4 Is payed P2P service = Y 100 56 3 23 Is payed P2P service = N 10 15 18 28 My idea is make a simple tool to investigate crosssales over services.
