topic Re: Seeing New Column in Base Table of Cube in SAS Web Report Studio

Seeing New Column in Base Table of Cube

DavidPhillips2 — Wed, 20 Jan 2016 21:54:48 GMT

I added a column to the base table of a cube. How do I add this new column to in Cube Studio?

Matthijs — Thu, 21 Jan 2016 07:50:10 GMT

- Update metadata for the table

- Go to Cube Studio

- Go to 'Inventory-tab'

- Fold out 'Cube'

- Select your cube

- Right click --> select Edit Structure

Now you can alter your cube and add additional dimensions (also based on the new column)

DavidPhillips2 — Thu, 21 Jan 2016 13:57:47 GMT

The new column in the table does not show up in the dimension selection window.

Matthijs — Thu, 21 Jan 2016 14:03:43 GMT

Strange.

The facttable with the new column is available in the correct environment?

You did update de metadata (via managementconsole or code) for the correct environment?

Otherwise I don't have an explanation.....