Hi,
I have an OLAP cube. One of the dimensions is based on a table called 'site_dim'. The table contains site_id, and site_description columns. Currently when browing the cube users can only see the 'site_id' field but they would also like to see the site_description.
I added the site_description as a member property of the site_id dimension and did a 'full process' on the cube to no avail.
Now I am wondering if I need to create a new virtual dimension?
Thanks.
I have an OLAP cube. One of the dimensions is based on a table called 'site_dim'. The table contains site_id, and site_description columns. Currently when browing the cube users can only see the 'site_id' field but they would also like to see the site_description.
I added the site_description as a member property of the site_id dimension and did a 'full process' on the cube to no avail.
Now I am wondering if I need to create a new virtual dimension?
Thanks.