After session calculated member created with CREATE MEMBER statement,
schema rowset MDSCHEMA_MEMBERS doesn't contains newly created member,
why?
Is this by design or bug

Example:

Using RowSetViewer (Microsoft Data Access SDK application) to test

Execute create command

CREATE MEMBER [Direct Sales].[Measures].[g1] as 1

to test what g1 exists we execute select command

SELECT FROM [Direct Sales] WHERE ([Measures].[g1])

test - ok

In same session in RowSetViewer get MDSCHEMA_MEMBERS rowset with
restrictions CUBE_NAME=Direct Sales
DIMENSION_UNIQUE_NAME=Measures

But resulting rowset doesn't contain g1 member

Note that MDSCHEMA_MEASURES rowset does contain g1

I can reproduce this behavior in Data Warehouse Explorer (DWE)
Newly created calculated member in Direct Sales cube don't displayed

build 2153

Vladislav Beliaev

VBeliaev писал(а):