web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / New created Table can ...
Microsoft Dynamics AX (Archived)

New created Table can be added to Cubes in SSAS 2012 R3

(0) ShareShare
ReportReport
Posted on by BanuReddy 287

Hi all,

I have created new table called EmpDepartment Table . In this table i have Four fields EmpId,Department Name, Total Number of Hours Worked, Date

I add this table to  my perspectives and assigned Attributes and Measures for this table. 

Attributes - EmpId,Department Name, Date

Measures - Total Number of Hours Worked

Then I created new SSAS project and Project generation is also success and when I am trying to deploy the Project . 

"Perspectives not found " error occurs.

Can new tables can be used in cubes ???

Can one anyone help me on this . 

*This post is locked for comments

I have the same question (0)
  • nunomaia Profile Picture
    nunomaia 25 Moderator on at

    Can you open Analisys Server in SQL Server Enterprise Manager and check if the cube was deployed properly ?

  • BanuReddy Profile Picture
    BanuReddy 287 on at

    I opened Analysis Server in SQL Server Management Studio. New Database and cube is not created .

    I don't  know how to open in SQL server Enterprise Manager .

  • nunomaia Profile Picture
    nunomaia 25 Moderator on at

    Did you executed "Analisys Services Project Wizard" in AX do deploy the Cube ? If isn't in Analisys Services, then you must deploy it

  • BanuReddy Profile Picture
    BanuReddy 287 on at

    When trying to Deploy cubes only i got an error "Perspectives not found".

    Therefore I can not able to deploy cubes

  • nunomaia Profile Picture
    nunomaia 25 Moderator on at

    Did you add the new perspectives to cube ?

  • BanuReddy Profile Picture
    BanuReddy 287 on at

    Yes I created New Perspectives called Test and add that Perspectives to Cubes

  • Verified answer
    Lance [MSFT] Profile Picture
    Lance [MSFT] on at

    First off, make sure the Usage property on your perspective is set to OLAP.  If that property is not set, generate will just give you an empty project, which might be why it can't be deployed.

    It's not clear if you are adding a new table to an existing perspective -- which would mean you are trying to modify an existing analysis services database,  or if you are adding a completely new perspective, which would create a separate analysis services database.

    If you are trying to modify an existing analysis services database, then use the update option in the cube wizard rather than the generate option.  That should combine your changes into the exiting cube project.

    If you keep getting that deploy error, find the analysis services project you generated or updated in aot and choose edit to save it to disk.  Then try deploying the project from sql data tools, which tends to give clearer error information for cases where the project can't be parsed for some reason.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans