Post reply

New fact table not listed during create New Partition

  • January 4, 2017 at 6:18 am

    #316584

    Hi, I have no experience in SSAS and have a problem.

    I want to create new partition for my existing Cube. Steps I did:

    - in VS 2010, open the SSAS project

    - in Data source View (DSV), create New name Query, put the query from last year NamedQuery fact table's query and change the year.

    - in DSV, try to Run or Explore data and looking good.

    - Double click the cube for editing.

    - Checked in Edit form - Tab Cube, data source view, my new NamedQuery exists.

    - Go to Tab Partitions

    - Create New Partition, Wizard opened, within the same Measure Group (because it is the only one), already correct Data source view (because it is the only one), but in Available table, I do not see my new NamedQuery.

    After create new NamedQuery, I tried to Build, Rebuild, Deploy the project and successful. Still when create New partition, the new NamedQuery not appear.

    Please help.

    Thanks.

  • January 4, 2017 at 9:49 am

    #1920679

    Hello everyone,

    Really appreciate any help. Is the steps that I wrote not clear enough or somehow confusing? please advice what else I could explain to make it more clear.

    Many thanks in advance.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply