Integration with R - Load data doesn't work properly

Carmine_Caruso · 2023-11-09T18:16:30+00:00

There was an error rendering this rich post.

Hello,
I experimented the following problem. After execution of R statements, the DataReader doesn't work properly, but laods only a few items.
I'm sure that R dataframe has more the 100 items, because I write them on a file.
After the data loaded, DataReader show as number of rows loaded the right number, but in the cube i only see 3 items loaded.Is there some paramiter configuration to set ?

Thanks in advance

Carmine

Find more posts tagged with

Accepted answers

All comments

Scott Bloxsome

Hi Carmine,

The number of rows and the items being loaded may be due to duplicate loads or rows containing empty values for cube data, if it's in replace time slice mode this may appear as just 3 items from 100 rows even though there are 100 rows in the source. I'm also assuming here that all 100 rows have been validated and not rejected. Let me know if this helps.

Scott

Carmine_Caruso

The dataframe contains all distinct and valued rows

As I wrote, I exported the dataframe to a text file and checked the contents.The text file loaded via dataload loads properly all the rows

Reagrds

Carmine

Scott Bloxsome

Hi Carmine,

Glad you found a workaround, one for the platform team to be able to respond on regarding the direct integration method if the flat file isn't scalable for you use, otherwise happy days!