Solution for not able to add tables in Warehouse Catalog

Issue: Not able to add tables/views to the Schema in Warehouse Catalog

Error: ‘Error adding Table(s) to the schema. This key is already associated with an element of this collection’

Solution in MSTR 9:

1) Open ‘Architect’,

2) Right click the table <table name>

3) Add to the project

4) once its added, Right table in Left Pane and update structure

5) Save and close (it will ask for Update Schema, so do the same

6) Now open Warehouse Catalog

7) you can see the table/view added to schema

About Senthilraj

DW BI Architect and BI Project Management (Specialized in MicroStrategy). Hobbies/Passion about photography, tennis, music, travel-trekking. Website: www.b-diamonds.com www.facebook.com/SENRAJ81 www.linkedin.com/in/senraj


Notice: compact(): Undefined variable: limits in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Notice: compact(): Undefined variable: groupby in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 821

Warning: count(): Parameter must be an array or an object that implements Countable in /home1/microoat/public_html/blog/wp-includes/class-wp-comment-query.php on line 399