Start Free Trial

asked on

Where is cube designer?

This is a related question to this

https://www.experts-exchange.com/questions/28508348/Howcome-this-query-brings-back-rows-regardless-of-where-clause.html

I want to:

Do you have measures that are not associated with the Brand dimension? Check your 'Dimension Usage' tab in the cube designer.
If the measures are not associated with the dimension it won't matter what the filter is - it will effectively be ignored for those measures.

Where's the cube designer? This link also mentions cube designer and "Dimension Usage' but where is it? The cube is already designed. I even opened Solution Explorer in SSMS but I don't see the cube design.
http://msdn.microsoft.com/en-us/library/ms189650.aspx

Randy Knight, MCM

From within you solution in solution explorer, navigate to the cube itself. Cube Designer will be one of the tabs.

ASKER

let me see

ASKER

I don't see it, I've attached a screenshot. I see my queries listed but how do I get to the cube?
cube.png

ASKER CERTIFIED SOLUTION

Randy Knight, MCM

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

Yes, so how do I do this?

You need to open the SSAS solution in BIDS.

ASKER

Opening SASS solution in BIDS is not thru SSMS?

Randy Knight, MCM

Correct. BIDS is completely separate from SSMS.

ASKER

I don't think BIDS (what does it stand for?) is installed on this server. How can I check? what do I need to look for?

Randy Knight, MCM

Business Intelligence Development Studio. It should be in your SQL Server program group.

ASKER

let me check

ASKER

No, don't think it's installed. Please see attached. That's what I see
sql-server.png

ASKER

I don't see BIDS installed. Thanks