Here is an image, I have redacted any company / personal information but it shouldn't affect anything. I am at a loss, is there something about the way the pivot table interacts with the connection that I am missing? Furthermore, if I create a new pivot table from that same connection in the SAME FILE it pulls in the correct data. Interestingly, if i copy the pivot table from the file that isn't displaying the data correctly, and paste it into a new file, the connection gets re established and the data gets pulled in. I am noticing extremely bad performance as it takes almost 15min to refresh a dataset with around 1400 records. Here is the issue - If I connect to the cube from a fresh excel file, the data gets pulled in just fine, however if i simply refresh the existing excel file that already has the pivot tables connected to the cube and the connection already established, I can view updated data for the months that existed previously, but I am missing the most recent month of data.īoth of the connections in the excel files are pointing to the same saved connection string in my "my documents > my data sources" folder. I had a few questions as I have an Excel connected to an OLAP source (SSAS Cube) and am trying to work with the Convert to formulas function which removes the pivottable and turns everything into CubeValue functions. Recently we have had to make a change to the Cube, specifically with regard to a date dimension and rolling over to 2014. So I have a monthly report that exists in excel with a connection to an SSAS cube.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |