Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ODC properties: OLAP Server Formatting
Hi,
I am trying to share my cube connections files (ODC) in a sharepoint data connection library, buy I can't set the "OLAP Server Formatting" options checked. What happens is the following: If I create a new ODC (for an analysis services connection), Excel 2007 shows the measures as formatted in the cube properties. The ODC "connection properties" dialog shows, under the Usage tab, all the "OLAP Server Formatting" ticks CHECKED. OK so far. Then I upload the ODC to a sharepoint data connection library. The problem is, when I open the ODC from sharepoint to an Excel worksheet, measures are shown without format. If, again, I open the ODC's "connection properties" dialog, all the "OLAP Server Formatting" ticks are UNCHECKED. If I recheck the "Number Format", everything works fine again... Do somebody know why are those checks changed?? Is it a property of the ODC, or of the Excel file?? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
default "Show calculated members from OLAP server" on in Excel 200 | Excel Discussion (Misc queries) | |||
OLAP and number formatting | Excel Worksheet Functions | |||
GetPivotData and SQL Server OLAP cubes | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
What do i enter in the server textbox to access olap? | Excel Discussion (Misc queries) |