User (Legacy) Posted June 14, 2004 Report Share Posted June 14, 2004 I am having an issue with the speed of the chart with OLAP extensions. When I hit the url of the chart we created, the page can take up to a minute to load. I was going to try the PSS extensions, but cannot get that to install. (see other post) Note that this is all on one machine. The olap server and web server are on the same machine, so there is no network speed to care about. Also, I have tracked it down to being a certain dimension of the cube causing this. The dimension is a hierarchy that has 300 members at the lowest level. If I exclude this, the chart works ok. Due to business requirements, this is THE most important dimension of the entire cube however. If I could capture information on the dimension I could load it in pieces. For instance they click a member of level1 and I could then create a new chart with the children of that member thereby keeping the number of members loaded to less than 20 at any point. However, I also can't seem to capture events from the dimension or which dimesion members are selected. Please help with any of these suggestions. I have tried multiple routes and cannot seem to fix the issue. Link to comment Share on other sites More sharing options...
Software FX Posted June 16, 2004 Report Share Posted June 16, 2004 Note that this speed issue will most likely be related to OLAP so I will try to focus on this issue and leave PSS for another thread. The first parameter we will need to track down is how fast the OLAP server is returning the data, you could try executing your MDX statement in the sample app included with OLAP Services. If you can duplicate this behavior using FoodMart please send us the MDX statement. >> If I could capture information on the dimension We sent a number of events but they were designed so that you could keep track of the current "state" of the OLAP chart (e.g. to change the state on a separate OLAP Grid) but we did not specifically test if the exposed events allow you to repopulate the chart. This sounds very useful so we will explore this for inclusion in a future service pack/version. Are you using ADOMD or XMLA ? Can you provide any details about the MDX you are executing ? -- Regards, JC Software FX Support "Phil Swartzell" <PSwartzell1@comcast.net> wrote in message news:dc7iWb7UEHA.3080@webserver3.softwarefx.com... > I am having an issue with the speed of the chart with OLAP extensions. When > I hit the url of the chart we created, the page can take up to a minute to > load. I was going to try the PSS extensions, but cannot get that to > install. (see other post) > > Note that this is all on one machine. The olap server and web server are on > the same machine, so there is no network speed to care about. > > Also, I have tracked it down to being a certain dimension of the cube > causing this. The dimension is a hierarchy that has 300 members at the > lowest level. If I exclude this, the chart works ok. Due to business > requirements, this is THE most important dimension of the entire cube > however. > > If I could capture information on the dimension I could load it in pieces. > For instance they click a member of level1 and I could then create a new > chart with the children of that member thereby keeping the number of members > loaded to less than 20 at any point. However, I also can't seem to capture > events from the dimension or which dimesion members are selected. > > Please help with any of these suggestions. I have tried multiple routes and > cannot seem to fix the issue. > > > Link to comment Share on other sites More sharing options...
User (Legacy) Posted June 17, 2004 Author Report Share Posted June 17, 2004 Thank you. You are correct. I assumed wrongly that olap was responding in a timely fashion. I had tested several incarnations of this query and they all responded fine, but after seeing your post I tested the exact MDX string in another application and the olap server is not responding well. I am still not sure what it is about this exact MDX, but it causes a serious delay on the olap server. I am therefore trying to work out a system so that I could then select level 1 of the hierarchy by default and let them "drill" in. I have something that works but not well. If the user clicks on a bar in the bar graph, I can grab the point, compare to the XAxis label, and thereby refresh the grid query. It works, but it is somewhat difficult and I can see areas where it is going to fail. Any help with "drilling down" (to members of the dimension not in the original MDX) would be very helpful. "Software FX Support" <noreply> wrote in message news:ORvdZe9UEHA.3080@webserver3.softwarefx.com... > Note that this speed issue will most likely be related to OLAP so I will try > to focus on this issue and leave PSS for another thread. > > The first parameter we will need to track down is how fast the OLAP server > is returning the data, you could try executing your MDX statement in the > sample app included with OLAP Services. If you can duplicate this behavior > using FoodMart please send us the MDX statement. > > >> If I could capture information on the dimension > > We sent a number of events but they were designed so that you could keep > track of the current "state" of the OLAP chart (e.g. to change the state on > a separate OLAP Grid) but we did not specifically test if the exposed events > allow you to repopulate the chart. This sounds very useful so we will > explore this for inclusion in a future service pack/version. > > Are you using ADOMD or XMLA ? > Can you provide any details about the MDX you are executing ? > > -- > Regards, > > JC > Software FX Support > > > "Phil Swartzell" <PSwartzell1@comcast.net> wrote in message > news:dc7iWb7UEHA.3080@webserver3.softwarefx.com... > > I am having an issue with the speed of the chart with OLAP extensions. > When > > I hit the url of the chart we created, the page can take up to a minute to > > load. I was going to try the PSS extensions, but cannot get that to > > install. (see other post) > > > > Note that this is all on one machine. The olap server and web server are > on > > the same machine, so there is no network speed to care about. > > > > Also, I have tracked it down to being a certain dimension of the cube > > causing this. The dimension is a hierarchy that has 300 members at the > > lowest level. If I exclude this, the chart works ok. Due to business > > requirements, this is THE most important dimension of the entire cube > > however. > > > > If I could capture information on the dimension I could load it in pieces. > > For instance they click a member of level1 and I could then create a new > > chart with the children of that member thereby keeping the number of > members > > loaded to less than 20 at any point. However, I also can't seem to > capture > > events from the dimension or which dimesion members are selected. > > > > Please help with any of these suggestions. I have tried multiple routes > and > > cannot seem to fix the issue. > > > > > > > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.