ivanchain


Hi, I was killed by one strange problem:

I made an OLAP Project in the BusinessIntelegent Studio, with right Dims, right cubes, right measures,and built it successfully. I put some data into the it's fact table and dimention tables in the SQL server, and ProcessFull the cube successfully.

From the Process Form's result record, it said that i have read 25000 rows into the AS cube.

I get to the BusinessIntelegent Studio's Cube Data Explorer, i mean the place just to explore the cube's data in a pivot table tool. I put any of the measures into the tool, but it always shows nothing(Empty). I sent a MDX to the server to select the same measure, and also got nothing (NULL).

Any friends have met this Thanks!





Re: Cant show anything in the AS's Cube Data Explorer

sidhuvirgoster


dear friend
go to the "calculated measures" tab of ur analysis services where u create the calculated measures...
there z a default "calculated measure" that comes under which u make and create all new measures..
i think by mistake u wud have deleted that default one..just go and create one more default calculated measure and i think its goona solve ur problem..
do post me back if the problem persist

regards
sid






Re: Cant show anything in the AS's Cube Data Explorer

ivanchain

Do you mean the first node of the default,that is, "caculate" in the calculated measures tab

No, I have NOT deleted that.

I found something. If I delete all dimentions and add one again, the problem will be solved. The problem is still there if I only delete one dimention and add it again. I need to delete All dimentions, but only need to add one again, the problem is gone.

Why

Thank u.







Re: Cant show anything in the AS's Cube Data Explorer

Vidas Matelis

Other things to check :

Have you specified default member on any dimension and/or attribute

Is there any attributes that have "IsAggregatable" property set to false

If you loaded many records and each measure value is 0 or NULL, at the end your result will allways be 0/NULL.

Vidas Matelis






Re: Cant show anything in the AS's Cube Data Explorer

ivanchain

1.What you mean default member

2.Yes, I have some attributes that have "IsAggregatable" property set to false. That is because my dimentions are father-son dimentions, so I set the fatherKey attributes's "IsAggregatable" property to false.

3.Of cause, my records's measure value is not 0 or Null. In fact, when I drop the dimention and then add them again the problem will go.

Thanks.






Re: Cant show anything in the AS's Cube Data Explorer

Vidas Matelis

1. For each dimension attribute you can specify default member. Then queries that do not specify anything for that attribute will use default member.In dimension editor when you select attribute, you can see property "DefaultMember". Lets your have country dimension/attribute and your fact records are assigned to european countries. But if you selecte default member "USA", by default your queries will be executed for "USA" country.

2. I guess this is your problem. Try to set IsAggregatable property to true and check for results. The way it works, that if you set this to false, then in queries where this attribute is not specified SSAS uses member from DefaultMember property. If there is no defaultMember specified for attribute with IsAggregatable=False, then default member is choosed for you. More info here: http://msdn2.microsoft.com/en-us/library/ms175626.aspx.

You might also experience strange results if more than one attribute in the same dimension has different specified default memeber.

Most parent/child dimensions by nature can be aggregatable, so double check if there is business requirement to set IsAggregatable to false there.

3. I was just double checking.

Vidas Matelis






Re: Cant show anything in the AS's Cube Data Explorer

ivanchain

Vidas£¬I found sothing.

Yes, my dimentions are all father-son type dimentions, and I set the fatherkey's attribute's IsAggregatable property to False. That's the cause. When I change it to True, I could explore the data now.

At this time, the father-son dimention's default member will be chosed as the top node. In fact that's why I could not see any data in the cube's explorer TAB. Because the records are bound to another node of the father-son dimention, which is not the son the the TOP node.

I checked the data records, and found an interesting thing.

I found that if I set the fatherkey's attribute's IsAggregatable property to False, and keep it's default member to Nothing, the father-son dimention will NOT have the ALL member. You could do this and check it in the dimention's explorer TAB, and you will find that the ALL member is gone. Why

Thanks.






Re: Cant show anything in the AS's Cube Data Explorer

Vidas Matelis

Ivanchain,

When you set IsAggregatable property to false, it is expected that that attribute will not have ALL member. This is by design. When IsAggregatable = False, you are telling SSAS that there is no point aggregating all members. More info here: http://msdn2.microsoft.com/en-us/library/ms174497.aspx

I am glad you found source of your problem.

Vidas Matelis






Re: Cant show anything in the AS's Cube Data Explorer

ivanchain

Thanks dear friends!