I am having a similar issue. I have 23 tables in cube, of which 18 are dimensions and 5 are facts. I am having issue in the initial stages, i.e. importing tables. All the tables except 2 facts are loaded. The facts that haven't loaded have 25Cr records. When I try to load the tables individually, they fail after importing 5Cr records. Can you please help me out here. I am giving few details that you have asked squareoff in the earlier post.
First what is the hardware you trying to run this on - CPU/Ram (total and available for SSAS) - Total 64GB, SSAS 8GB (calculated based on total memory and max memory for SQL), maximum memory for SQL is 50GB
Paging file max size -
free space on paging file drive -
OS version (and 32 or 64 bit) - 64 bit
SQL Server version - 2016
With regards to processing are you doing process full or other - Haven't reached the stage of processing yet
And with regards to the cube itself.
Are you telling us that you have multiple fact tables on a database and you combined them all into a single table/view? - yes
It is possible this is not the best option just from a usage point of view unless all source fact tables have all the same granularity.
On the processing - At what stage did it fail? - Read Data
And how many measures/calculated fields do you have on top of the columns you are processing. - None
And finally what is the data type of the columns and their cardinality. - int, bigint, float, numeric, varchar
We have tried the below:
- setting the VertipaqPagingPolicy to 2.
- tried importing only the fact table in a new project.
- Also tried changing the default values of LowMemory and TotalMemory on the SSAS server properties.