How to get current MDX query in action expression?

Does somebody know how to get current user (logon user) in an action of a workflow definition from the Sharepoint Designer 2007. I know how to do it by using .NET coding, but it requires to upload a dll to the bin directory of the application which is not an option due to my company Sharepoint policies.

I would like to use xmlhttp request to display the current users unread email count in a webpart.  I can get this to work if the user enters their username & pw, but I'm not able to get any pass-thru credentials to work.  How can we set this up to pass through the current user's credentials.  We tried to set the sharepoint wfe with kerberos trusted delegation, but this doesn't seem to work.

We do not want to create an account with full access to all private mailboxes.

HI All,

I´m trying to write a query for a list view that should return all items if the current user belong to a group. If the user doesn´t belongs to this group, no items should be returned.

So far, I could find many equal examples about using the CAML Membership element in a comparison with an AssignetTo field. But not making a comparison between the current user and a specific Sharepoint Group.

Any suggestions, please?

Thanks

Hi,

 

Could anyone please let me know how I could use the VBA function Now() to get the current time and assign it to the (year-month) hierarchy?

I need this for a report which retrieves amount collected in the past 24 months from the current date.

I have read that I could use the VBA functions but I am not sure how to assign it to the time dimension hierarchy and then use the LASTPERIODS function to get the past 24 months of data.

 

Any help would be greatly appreciated.

 

Thanks.

Hello. I need to query current logged user private tags.

I want to show a links.

I'm using the following code:

using (SPSite site = new SPSite(@"http://dev2:27397/"))
      {
        using (SPWeb web = site.OpenWeb())
        {
          SPServiceContext serviceContext = SPServiceContext.GetContext(site);
          SocialTagManager tagManager = new SocialTagManager(serviceContext);
          UserProfileManager userManager = new UserProfileManager(serviceContext, true);
          
          SPUser user = web.CurrentUser;
          UserProfile userProfile = userManager.GetUserProfile(user.LoginName);

          var allTags = tagManager.GetTags(new Uri("http://dev2:27397/Lists/TaskList/..."));
          var onlyOpenTags = tagManager.GetTags(userProfile);                   
        }
      }

Here I can get private tags for specific url and public for user.

But how to get private and public tags for current User?

I'm currently develop a monitoring and evaluation database with many indicators

For example: I have two input  indicator :  car , truck

Input_IndicatorID        quantity

Car                               3

Truck                            2

I'd like to create an output indicator have field: formular. The result of vehicle = car + truck = 5

Output_indicatorID      formular

Vehicle                         Car + truck

I don't now how to parse this string, detect parameter: car, truck  to get the answer

I search on Google and find some Math parse like:  muParser, bcnet  but it just for a string

Please help me solve this

Hi,

I have this issue that CQWP is rendring items that it should not render. I test this with a read-only user, that should NOT see draft pages or pages with different permissions. But the read-only user do see the items, but when I click on the link I get access denied. This access denied is correct, but why does the page items appear in the CQWP at all?

Facts:

1) I use OOTB CQWP (inherits from ContentByQueryWebPart in my .webpart file) : "<type name="Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart ....." and I have my custom xsl to get the look and feel I need

2) The issue with page items showing when status = drafts only appear when using the PublishingExpirationDate field. When I try creating new pages and give them status draft by using "check in to share draft" (logged on as an contributer/approver user), this item wil NOT appear in the CQWP for the read-only user. When I change a pages' status from approved to draft, this item will still be shown in the CQWP, but this will point correctly to the published version. But after the pages' expired date (PublishingExpirationDate) is expired, the page gets status "draft" (handeled by a timer job I guess), and this page item will still be rendered in the CQWP, but sending the read-only user to an access-

Hello guys,

I am currently browsing a cube with MDX using this query

select [Measures].[LOAN] on columns,[Dim Period].[PERIOD].[PERIOD KEY].&[201001] on rows from skyebank_financial_cube

The above query hardcode the year and the month from the Period dimension, however is there a way I can modify the query to dynamically find the current year month and year in the cube.

Thank you

Hi,

I have a SQL query which calculates the full name from firstname, middlename and lastname. When any of the column contains a null value the calculated value shows null.

FirstName + ' ' + MiddleName + ' '+ LastName as FullName

from <table name>

FirstName : Ruben

MiddleNAme : Null

LastName : Torres

FullName : Null

Why it does not leave the null column and have the string concatanated as :

Ruben Torres

Thanks,

Grahi.

I need to retrieve current connection Id from the cube. I need to do this in 'Action expression' field at Action definition. ConnectionID will be later used for searching proper entries in sql server traces.

How can I get this?

I'm writing a global action filter and would like to determine if the currect action is asynchronous.  However the ActionExecutingContext doesn't expose any properties for me to make this determination.  I can get a handle on the controller if it is an AsyncController assume that the action is also asynchrous. However that doesn't guarantee that the current action is asynchronous since you can have a synchrouns action in a AsyncController.

We have a distributed team, so there is the potential for a filter to invoke a service asynchronously on a synchonous action.  This particular filter needs to access the session store, which is unavailable in this scenario.