Forum Discussion
Modify a query
- 10 years ago
Hello,
All of your queries provide from a cube (ssas for example) ?
The cube system is a specific data model and type of connector.
Hello,
I had the same experiences already a view times. Different queries are open and it is no longer possible to modify them with "cube settings". Thank you for your answer Haegi, but for me the problem is not solved. I can add new columns for calculations and open new queries, but it is not possible to add new data in an existing query. Why?
This has happened to me as well. Does anyone have a solution?
- pqian10 years agoMicrosoft Employee
The Cube transformation menu is only available when your query is fully folded to be executed on the server. If a local transformation is involved, then we break out of multidimensional mode and you are only dealing with a tabular model from then on.
You can always add more items by double clicking the "Added Items" step instead.
Another note: the top left corner of the table gives a hint of the "cubeness" of the query:
Left one is Cube, right one is table