- CubeMaxRecords — Specifies the maximum number of records that are returned by an analysis for the view to process. This roughly governs the maximum number of cells that can be populated in a view; unpopulated cells in a sparse view do not count. The default is 40000.
- CubeMaxPopulatedCells — Specifies the maximum number of cells in a view that can be populated with data from the Oracle BI Server. The default is 120000.
From the doc, always a good place where to look for answers
Setting them to 100'000'000 sounds like you want to do data pump via OBIEE: wrong tool for the wrong need.
As you can see How to Ask Questions in Developer Community Spaces there are multiple information you can provide when asking a question to get some answers, otherwise it's just random guesses.
First: Why the numbers configured are in thousands billions? Use SQLLDR for data pumping, you will surely get a better performance than OBIEE.
Second: Definitely issue is not at DB end. Try creating a complete new analysis by pulling one column at a time, you can check where the problem lies in.
Third: Try taking physical SQL from BI diagnostics, and run the same in SQL developer.
Hope this helps.