Insert measure value data into the cube.
insert {cube_name}
(
{dimension_role_name}.{member_full_path} [ , {dimension_role_name}.{member_full_path} ... ] measures {measure_name} {numeric} [ {measure_name} {numeric} ... ]
)
[ ,
(
{dimension_role_name}.{member_full_path} [ , {dimension_role_name}.{member_full_path} ... ] measures {measure_name} {numeric} [ {measure_name} {numeric} ... ]
) ...
];
{cube_name}
The cube name, which needs to be enclosed in square brackets.
{dimension_role_name}
The name of the role this dimension plays in the cube, which needs to be enclosed in square brackets.
{member_full_path}
The full path from the root member to the current member.
{measure_name}
The name of the measure in the cube, which needs to be enclosed in square brackets.
{numeric}
The value of specific measure.
insert [Online Store]
([Store Type].[ALL].[Platform Self-operated Store],[Payment Method].[ALL].[Credit Card],[Goods].[ALL].[Kitchen & Dining].[Bento Boxes],[Calendar].[ALL].[2020].[Q1].[M1] measures [sales amount] 10 [sales quantity] 1 ),
([Store Type].[ALL].[Platform Self-operated Store],[Payment Method].[ALL].[Debit Card],[Goods].[ALL].[Kitchen & Dining].[Bento Boxes],[Calendar].[ALL].[2020].[Q1].[M1] measures [sales amount] 10 [sales quantity] 1 ),
([Store Type].[ALL].[Platform Self-operated Store],[Payment Method].[ALL].[Account Balance],[Goods].[ALL].[Kitchen & Dining].[Bento Boxes],[Calendar].[ALL].[2020].[Q1].[M1] measures [sales amount] 10 [sales quantity] 1 );