.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Font didn't change in excel, after change was made on SSAS

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
 
Hello!   After I wrote MDX, I gave to my calculated field a format of “courier New” and font size of ‘9’. When I connected to SSAS using excel, and pulled my data but I don’t see the right format that I used. It is not working for any format. I used 2008 SSAS. What is the issue? Thx, Beney


View Complete Post


More Related Resource Links

How to change connection string of a pivot table pointing to SSAS 2005 cube using excel 2003?

  
Hi All,I am not sure if I should have posted this query to Excel 2003 forum. But posting it here as it applies to SSAS 2005 as well.Ok, let me give the background before I tell the actual problem.We have users on ABC domain and the SSAS server is also on ABC domain. Users on this domain can acess the excel pivots by connecting to cube to browse the data. They leave the Userid & password field blank while they setup the connection string and it works fine. Thanks to windows authentication that takes the credentials of user logged in. Let's say I have two users A and B, they login to ABC domain with their own windows ids.  Now when user A creates a excel file having a cube pivot and then sends this file to user B, user B can refresh and modify the same excel file (he can select new measures to pivot, new hierarchies in filters and so on).Now, let's say I have another user, user C. He has excel 2003 installed on his PC and cannot migrate to excel 2007. He is on different domain XYZ but have a valid windows userid on domain ABC. The domain ABC & XYZ can not be setup to have trusted relationship. Now, when user A sends the same excel file to user C. When user C opens the file and try to refresh it or try to modify the pivot by selecting/deselecting any elements, he gets below error prompt:" An error was encountered in the transport layer." and "Errors in the

With Excel pivot table client using SSAS cube, how to change the measures to rows?

  
I want the measures as rows instead of columns in Excel pivot table on a SSAS 2008 cube. How do I do that? Thanks.

Is it possible to change the title bar background and the font style on default template?

  

Hello,

Is there any way to change the default top link /title bar picture and the fonts of the title without breaking anything in the layout/structure?

I have changed the theme to Obsedian and I would also like to change the picture of the title bar of this theme and also the font/style of the title, top link bar, menus..etc. Is there a way to do this?

Please note: I am using WSS 3.0 and I am not the Administrator of the sharepoint. I am only the site admin of some sites on this sharepoint. I can do some basic customization using SPD.

Basically, what I am trying to do is that I want to set up a sharepoint site, however I want to make it NOT look like a sharepoint site.Well I know this is possible, but for my case it might be just partially possible due to the limitation that I am not the Site collection admin and hence I do not have direct access to the server itself.

What I want is to hide most of the sharepoint links/menus/bars, etc and use my own buttons/hyperlinks etc .. for user to navigate on the sites.

Thanks in advance for your help/advices.

Regards

Rooven


change the font color according to the column

  

hi,

i have a column in the list which has values 1.Added

2.Chnaged

3.Killed

i want to make the field values Killed to be make it as Red so i tried in sharepoint designer converting to xslt data view then did formatting but the problem is i am not able to see the edit in data sheet option. can you please is there any way i can have both to be working? or is there any alternate solution for formatting column based on values

thank you so much.

 

 


cannot get the crystalreport1.rpt to recognize the change made to the datatable, help..

  
added a dataset.xsd file, kept a datatable in it, nothing elsebinded the dataset as a datasource for the srystalreport1.rptnow my aim is to, make the dataset populated by code to appear in the report (note the gridview does recongize the change, also note i have tried using the init page method but no luck)heres the code behind.        DataSet1 ds = new DataSet1();        //DataTable dt;        DataRow dr;        DataColumn idCoulumn;        DataColumn nameCoulumn;        int i = 0;        //dt = new DataTable();        idCoulumn = new DataColumn("ID", Type.GetType("System.Int32"));        nameCoulumn = new DataColumn("Name", Type.GetType("System.String"));        ds.DataTable1.Columns.Add(idCoulumn);        ds.DataTable1.Columns.Add(nameCoulumn);        dr = ds.DataTable1.NewRow();        dr["ID"] = 1;        dr["Name"] = "Name1";        ds.DataTable1.Rows.Add(dr);        dr = ds.DataTable1.NewRow();   &nb

How do I change the backlground and font color of a web part header - Sharepoint 2010

  
Hello,  Im verya mateur with Sharepoint so bare with me.   We are running Sharepoint 2010 and I am settingup a basic site for our company.  What I need to know is there a way to change the color of the web part header.   I have a calendar web part that displays a list of our holidays, and I was able to change the background color of the content as well as the font colors for the list of holidays,  but I cannot seem to change the background for the title box where it says Holidays and Events remains with a white background.   I would appreciate any help!   Thanks   Charlie   charlieprice@live.com

Need to learn how to change FONT SIZES within web parts through Sharepoint

  
I'm a new user to Sharepoint 2010 - have casually used Sharepoint Services since 2.0. I'm trying to find a way to change the FONT SIZE of Links in a LINK web part - there does not seem to be a user-friendly option for this.  How can I increase the font size of links in a LINK web part, so that the user can see them more easily?  Does it require something in Sharepoint Designer to do this?  If so - is there any info on easy steps to navigate Sharepoint Designer, to do a simple task like increasing a font size of the links?

Hyperlinks embedeed in excel change when checked out in sharepoint 2007 and saved as local copies.

  

I have an excel folder that is used by several people.  Each has the ability to edit and save changes to track training classes they have attended.  Each person's name in column a is a hyperlink to a sharepoint folder to which is only accessible by the individual and their managers.  When a user checks out the document, they are asked if they want to open the file as a local draft.  If they select yes, when the document is saved back to sharepoint the hyperlinks have changed to the local copy of the user's workstation.  This prevents users from accessing their folders.

Can I turn off the ability to save to a local copy?  How can I prevent the hyperlinks from changing?

thanks


When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1

  
When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1,Sheet 2,Sheet 3) dynamically.So Please try to give me a solution.

When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1

  

 

When i export a MS Excel file generated By SSRS 2008 i'm not able to change the sheet name (Sheet 1,Sheet 2,Sheet 3) dyanamically.Sp Please try to give me a solution.


The Accordion Control change font controls

  

Hi, I use an accordion control that contains some aspnet control inside. 

When I collapse the accordion control, all of aspnet controls include labels or textboxes change the font to another differnt, what can I do.


There is the code:

<cc1:Accordion ID="Accordion1"  Width = "100%" runat="server"  FadeTransitions="True" SelectedIndex="0" TransitionDuration="300"  HeaderCssClass="accordionHeader" ContentCssClass="accordionContent">

            <Panes>

                <cc1:AccordionPane id="AccordionPane1" runat="server" >

                <Header> Datos Generales de la Póliza</Header>

                <Content>

                         <asp:Label ID="Label6" runat="server" Font-Bold="True" Font-Names="Tahoma" Font-Size="8pt" CssClass="labelFormat"

                               &nb

Is possible to change parameter's font?

  

Hello

I made "Last Names" parameter to filter data, but users can not read  this text. Is possible to change font for this parameter?

 


How to change the background and font color of text for a web part header - Sharepoint 2010

  

Hi I am trying to change the font color and text Header color of the web part, can any one help me with that

Thanks


treeview selected node font style does not change

  

Hi All,

I have a treeview and I am giving the node style in code behind.

Treeview design is as below:

<asp:TreeView ID="tvIARHierarchies" runat="server" NodeIndent="15" ShowExpandCollapse="true"
                                        ShowLines="True" Width="98%" OnSelectedNodeChanged="tvIARHierarchies_SelectedNodeChanged">
                                        <ParentNodeStyle Font-Bold="False" />
                                        <HoverNodeStyle Font-Underline="True" ForeColor="#6666AA" />
                      &n

Undocumented behavior change - SSAS 2008R2

  

Under SSAS 2005 or 2008, running the following MDX

select { StrToMember(@Date) } on 0 from [Any]

against any database results in the error:

Parser: The query contains the Date parameter, which is not declared.

which is the correct error message.

Under SSAS 2008 R2, this results in the error:

Query (1, 23) Parser: The syntax for 'Date' is incorrect.

even if the value for the @Date parameter is supplied with the query (e.g. from as SSRS dataset or any other XMLA client). Any parameter (that I've tried) with a name other than @Date behaves as expected.

This is a breaking change that's not listed (near as I can tell) in any list of changes to SSAS for 2008 R2.  In fact, the "What's new in SQL Server 2008 R2" does not admit that there were any changes in SSAS at all.

Can someone from the product team confirm that this is a breaking change in 2008R2 and whether it's just a bug, or did @Date take on some new, undocumented meaning in 2008R2?


-cd Mark t

Regarding realtime update of SSAS cube when underlying data change

  

Hello All,

This is regarding the automatic update for SQL Server Analysis Service cube incremental update.

We have developed one cube which contains item details with several attributes.

And in our application, we have built search and to get result we are querying that cube. Now whenever new item is added or any of its details changed, we want to update the cube with changes.

I already know, that we can do it via scheduling cube processing at some small interval. But we want to have some real time optimal solution to update the cube.

If anyone has idea about any optimal method, please let me know. Its very urgent.

Thanks in advance.

 

 


Darshan Vyas

Regarding realtime update of SSAS cube when underlying data change

  

Hello All,

This is regarding the automatic update for SQL Server Analysis Service cube incremental update.

We have developed one cube which contains item details with several attributes.

And in our application, we have built search and to get result we are querying that cube. Now whenever new item is added or any of its details changed, we want to update the cube with changes.

I already know, that we can do it via scheduling cube processing at some small interval. But we want to have some real time optimal solution to update the cube.

If anyone has idea about any optimal method, please let me know. Its very urgent.

Thanks in advance.

 


Darshan Vyas
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend