Question on URL action on cube objects

Hi, all experts here,

Thanks a lot for your kind attention.

I am having a question on the URL action on cube objects. The question is about the URL expression. It seems like we cant jsut pasted the URL there?

I am looking forward to hearing from you for your help.

With best regards,

Yours sincerely,

No, you need to supply an MDX expression which resolves to a url. So if you just want to hard-code a url in your action, you need to enclose it in double quotes, for example

"http://www.google.com"

HTH,

Chris

|||

Thanks a lot.

Best regards,

Question on IFilters

Hi,
Are the Ifilters COM/CORBA objects that I could call from my code? I'm trying to find out whether I could call them in my java code to extract text from various document formats such as PDF/MS Office etc before storing them to the database. The document
s that we are looking for full text search are on the average 100Mb in size and I'm looking at ways to cut down the size before storing them in the SQL server database.
Appreciate your reply,
Anantha
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
Anantha,
The best information source for this is the MSDN Platform SDK "Using Custom
Filters with Indexing Service" at:
http://msdn.microsoft.com/library/de...ufilt_912d.asp
Specifically, click on "Filter Samples" -> HtmlProp Sample:
http://msdn.microsoft.com/library/de...ufilt_0lwl.asp
This provides examples of how to "extract value-type properties. It converts
HTML meta properties to data types other than strings as specified by a
configuration file."
Hope that helps!
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Anantha Padmanabhan" <ananthapus@.hotmail.com> wrote in message
news:#l$5EyZ$EHA.3472@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Are the Ifilters COM/CORBA objects that I could call from my code? I'm
trying to find out whether I could call them in my java code to extract text
from various document formats such as PDF/MS Office etc before storing them
to the database. The documents that we are looking for full text search are
on the average 100Mb in size and I'm looking at ways to cut down the size
before storing them in the SQL server database.
> Appreciate your reply,
> Anantha
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
|||They are com objects, you can call them from code. Here is an example of how
to call them.
http://sqljunkies.com/HowTo/C4AC6E97...E63EC99B6.scuk
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Anantha Padmanabhan" <ananthapus@.hotmail.com> wrote in message
news:%23l$5EyZ$EHA.3472@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Are the Ifilters COM/CORBA objects that I could call from my code? I'm
trying to find out whether I could call them in my java code to extract text
from various document formats such as PDF/MS Office etc before storing them
to the database. The documents that we are looking for full text search are
on the average 100Mb in size and I'm looking at ways to cut down the size
before storing them in the SQL server database.
> Appreciate your reply,
> Anantha
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
|||Thanks John/Hilary for your reply and links.
I have another question though. If I store only txt documents in the SQL server (all other docuemnts are converted into txt documents before storing them in the database) does the indexing service still use the filter (in this case the standard filter) t
o extract textual data for indexing purposes?
Anantha
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||yes, it uses the default or null iFilter.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Anantha Padmanabhan" <ananthapus@.hotmail.com> wrote in message
news:%23rnRWam$EHA.208@.TK2MSFTNGP12.phx.gbl...
> Thanks John/Hilary for your reply and links.
> I have another question though. If I store only txt documents in the SQL
server (all other docuemnts are converted into txt documents before storing
them in the database) does the indexing service still use the filter (in
this case the standard filter) to extract textual data for indexing
purposes?
> Anantha
>
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
|||You're welcome, Anantha,
Yes, it does. However, keep in mind how you import or insert the text can be
important as well as where you store the row text. You may want to consider
using TextCopy.exe that ships with SQL Server 2000.
Thanks,
John
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Anantha Padmanabhan" <ananthapus@.hotmail.com> wrote in message
news:#rnRWam$EHA.208@.TK2MSFTNGP12.phx.gbl...
> Thanks John/Hilary for your reply and links.
> I have another question though. If I store only txt documents in the SQL
server (all other docuemnts are converted into txt documents before storing
them in the database) does the indexing service still use the filter (in
this case the standard filter) to extract textual data for indexing
purposes?
> Anantha
>
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...

Question on Cube actions

Hi, all experts here,

I am having a question on cube actions. What is the easiest way for us to see all actions properties(including objects to trigger the actions, etc.), hope it is clear for your help and I am looking forward to hearing from you shortly.

Thanks a lot in advance.

With best regards,

Yours sincerely,

Hello Helen. Are you missing any information in the actions tab of the cube editor?

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thank you very much for your kind attention.

Well, I asked the question from a end-user point of view like when they browse their data from end clients like Excel 2007, rather than respectively click on each object displayed in Excel to see know available cube actions, is there any way that they can have an overview of all available cube actions on the cube they are browsing in Excel? So that they are able to have a whole idea of what actions are available on the cube.

Thank you very much again for your kind advices and I am looking forward to hearing from you shortly.

With best regards,

Yours sincerely,

|||

Hi Helen. I have not seen this option in Excel2007. I think it is only possible by right clicking a member.

Regards

Thomas Ivarsson

|||

Hi, Thomas,

Thank you very much for your very kind atttention and advices and help.

With best regards,

Yours sincerely,

|||I suppose you could shade the back color of all cells that have actions on them using a Back_Color(this) = assignment in the calc script. I personally think that would clutter a spreadsheet, but it's an option if you're desperate.|||

Hi, Furmangg, thank you very much for that. It's been very helpful advices.

With best regards,

Yours sincerely,