question

ArunRaaman-6281 avatar image
0 Votes"
ArunRaaman-6281 asked LukasYu-msft edited

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

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://docs.microsoft.com/en-us/analysis-services/multidimensional-tutorial/lesson-5-2-defining-a-fact-relationship?view=asallproducts-allversions77939-defining-a-fact-dimension.png


sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft edited

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



image.png (29.7 KiB)
image.png (23.9 KiB)
image.png (22.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.