How to add new Dimension Attributes to the existing dimension through BIDS
I have a customer dimension. While creating cube and defining dimensions the default attributes will come along with the cube creation. I want to add some more attributes after creating the dimensions. How to do this. I tried with "Add Business Intelligence" option, but I failed. Is there any way to do like that. If we remove the dimension and add the dimension again, we can have a interface as "Select dimension attributes". But with out deleting the existing dimension, how to add the attributes to that dimension. Following screen illustrates adding dimension attributes. How to see this interface for existing dimension.
After clicking the dimension attribute tab and clicking on the "Edit datasource" option.. following screen is showing. Here where we can add the attributes?
Assuming that your DSV includes the columns that you want to add as attributes, and assuming that you have an existing dimension, you cannot open the Dimension Wizard again to add more attributes to your dimension. Instead, on the Dimension Structure page (as shown in Diego's screen shot), you have the Attributes pane on the far left where each attribute is listed and you have the Data Source View showing the diagram of your table. You drag a column from the diagram on the right to the Attributes pane on the left. That creates a new attribute.
The image above shows the cursor appearance as you drag the column into the Attributes pane. The image below shows the Attribute pane after you release the mouse button - the new attribute appears as shown.
- migrate data from MS SQL to PostgreSQL?
- Sqoop Import HBase - SQL Database
- How important is the order of columns in indexes?
- Connect to SQL Server running on Windows host from a WSL 2/Ubuntu sqlcmd
- SQL Server, to normalize this much or not?
- Strange behavior of symfony doctrine during phpunit test - field becomes null in database
- How do I make it to where my login will accept either an email or username in the username field
- Adding column to select statement in SQL causes timeout
- SQL Server: Clustered index on datetime, ASC or DESC
- SQL Pivot on Conditional Count
- SQL Server indexes - ascending or descending, what difference does it make?
- Query to concatenate row data in each group
- Combine 2 SQL Statements
- Converting SQL server timestamp to an epoch timestamp
- Change Date format from yyyy-mm-dd to mm/dd/yyyy Derived Column
- How do you send email with TSQL using a Agent Operator instead of an email address?
- Spark sending LIMIT to SQL Server on display function
- How can I manage Azure SQL user/login/credentials
- Can't add members to SSAS role through Visual Studio
- How to use Charindex for one or the other character
- SQL want to calculate time hours and mints of each emp
- Incorrect Syntax near ',' in SQL query execution in Spring JPA but executes successfully in database
- How to make multiple select into on the same table?
- Invoking a stored procedure with all combinations of values stored in multiple single-column tables
- Get Value From Json object contain table column using SQL Query
- Compute count(*) of unique occurrences into new column without group by in a single select query
- Is there any better option to apply pagination without applying OFFSET in SQL Server?
- How to get a list of tables with composite primary key in SQL Server?
- Calculating churn rate in SQL: how can I display both churned and not churned customer in % in a single query?
- How can you tell what Tables are taking up the most space in a SQL Server 2005 Database?