how to select a name column while creating a dimension under dimension list in SSAS?

ArunRaaman 1,001 Reputation points
2021-03-15T23:57:01.84+00:00

I am trying to create a Fact-Dimension based on the example given in the AdventureWorks-SSAS documentation (the web-link for the document was given below). As I followed through the steps given below, I couldn't find the name-column list in step 7; it can be understood from the screenshot that I attached to this question.

In Solution Explorer, right-click Dimensions, and then click New Dimension.

On the Welcome to the Dimension Wizard page, click Next.

On the Select Creation Method page, verify that the Use an existing table option is selected, and then click Next.

On the Specify Source Information page, verify that the Adventure Works DW 2012 data source view is selected.

In the Main table list, select InternetSales.

In the Key columns list, verify that SalesOrderNumber and SalesOrderLineNumber are listed.

In the Name column list, select SalesOrderLineNumber.

Click Next.

Would anyone please help me understand why I couldn't go further from step 7.

Thank you for considering to support my attempts.

https://learn.microsoft.com/en-us/analysis-services/multidimensional-tutorial/lesson-5-2-defining-a-fact-relationship?view=asallproducts-allversions![77939-defining-a-fact-dimension.png][1]

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,344 questions
0 comments No comments
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,826 Reputation points
    2021-03-16T09:54:30.637+00:00

    Hi,

    It looks like an VS issue, since the software update, there is some issue inside the UI logic.

    Anyway, try following step, it should work :
    First, click the triangle to choose blank for one key. And then, click anywhre in the red circled area.
    78140-image.png

    At this time the error should be gone. Then choose the name column as SalesOrderLineNumber.
    78198-image.png

    At last , add the previous SalesOrderLineNumber key back . You shoule be able to click next now.
    78199-image.png

    Regards,
    Lukas

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.