Search Results

Searching the library

You can search for basic names of files and data in the Files and data flyout. However, you can also search for particular types of library items, find the files that were last updated, or find all files updated by a certain person.

Searching for a text string will by default look for matching text in the title and keywords of the items in the library. You can use wildcards and boolean operators to search for parts and combinations of words.

Library specific search

Keyword

Example

Function

title:<word in title> title:sales

Locates library items with the specified word (or part of word) somewhere in the title.

created_by: <username>

created_by:admin

created_by::admin

Locates library items created by a certain user.

In the first example, all items modified by any users beginning with admin will be found. In the second example, only items modified by the user 'admin' will be found.

modified_by: <username>

modified_by:admin Locates library items modified by a certain user.
item_type:<type>

or

type:<type>

item_type:datasource

item_id::<GUID>

or

id::<GUID>

item_id::dac3cd8c-47ec-454a-a8f2-691c60ece052 Locates a specific library item based on its unique identifier.
connector: <connector name> connector:sql

connector:"Microsoft SQL Server"

Locates all data connections or connection data sources from a certain connector.

Use the adapter name or the full data connector name within quotes.

depends_on (<expression> ) depends_on(item_id::538bcde4-7212-475f-a348-5bb41ba39c41)

depends_on(Sales)

depends_on(type::dataconnection)

Locates all items that depend on a specific element.

If the GUID in the example to the left belongs to a data connection, the search will find all analyses that use that data connection.

required_by (<expression> ) required_by(item_id::6f6dc7e0-57bd-11d7-5ac0-0010ac110132)

required_by (title:MyAnalysis)

required_by(type::dataconnection)

Locates all items that are required by another item.
modified modified:"2 days ago"

modified:"a week ago"

modified:>"an hour ago"

modified:today

modified:<"this month"

modified::>created

modified:"2015-02-01T18:27:55CEST"

It is possible to search for items that have been modified during a specified time span, relative to today. There are two different ways of describing relative dates and times:

1) State the number of time parts ago in a string surrounded by quotes. The available time parts are seconds, minutes, hours, days, weeks, months and years. For example, search for modified:<"6 months ago". The given number of time units will be subtracted from the current time in the search.

2) State the time period to look back at using either of the keywords; today, yesterday, "this week", "this month", "this year". Note that you need quotes around all keywords consisting of more than one word. In this type of search, the last part of the date or time is "reset" (the time gets set to zero, the day of the month gets set to 1 etc.). The start day of a week is dependent on your server locale. For a en-US locale the first day of the week would be Sunday.

Modified, created and accessed can also be used in comparisons with each other. The example modified::>created locates all items that have been modified after their creation.

Modified can also be used together with a timestamp of ISO 8601 format ("yyyy-MM-dd'T'HH:mm:ssz") to find items modified at a specific time.

created created:>"this week"

created:<"2 weeks ago"

created:>"2015-02-01T18:27:55CEST"

It is possible to search for items that have been created during a specified time span, relative to today. See details regarding the allowed time spans under "modified" above.

Modified, created and accessed can be used in comparisons with each other.

Created can also be used together with a timestamp of ISO 8601 format ("yyyy-MM-dd'T'HH:mm:ssz") to find items created at a certain time.

accessed accessed:>"this month"

accessed:<"2 weeks ago"

accessed:null

accessed:>"2015-02-01T18:27:55CEST"

It is possible to search for items that have been accessed during a specified time span, relative to today. See details regarding the allowed time spans under "modified" above.

Modified, created and accessed can be used in comparisons with each other.

Accessed can also be used together with a timestamp of ISO 8601 format ("yyyy-MM-dd'T'HH:mm:ssz") to find items accessed at a certain time.

The example accessed:null finds all items that have never been accessed.

The last example finds all items that have been accessed after the first of February 2015.

::> modified::>created Used to finds items strictly greater than the expression following the operator.

For example, finds all items that have been modified after their creation.

::< accessed::<modified Used to finds items strictly less than the expression following the operator.

For example, finds all items that have been modified after they were last accessed.

parent_id:: <folder GUID> parent_id::538bcde4-7212-475f-a348-5bb41ba39c41

Locates all items located in the specified folder.

format_version: <string or null> format_version:null Locates all items of a specified format version. For example, all items which have no format version specified can be found.

Analysis files

When searching for analysis files, there are a number of search parameters that may help you locating a specific group of analyses. If you want to locate analysis files only, add type:dxp to the search expression.

Keyword

Example

Function

description description:sales

type:dxp description:sales

description::null

Locates all items containing the specified word in their description.

Locates all analysis files containing the specified word in their description.

Locates all items that are missing a description.

keywords keywords:sales

type:dxp keywords:sales

Locates all items containing the specified keyword.

Locates all analysis files containing the specified keyword.

AllowWebPlayerResume: <true or false> AllowWebPlayerResume:true If true, locates all analysis files that allow personalized views for all web client users.
EmbedAllSourceData: <true or false> EmbedAllSourceData:true If true, locates all analysis files that embed source data. (Override and embed all data check box selected.)
AllTablesEmbedded: <true or false> AllTablesEmbedded:true If true, locates all analysis files that only have embedded data tables.

Combinations of keywords

You can combine many of the keywords described above to create more advanced search expressions. For example:

type:dxp depends_on(type:dataconnection title:Salesforce) - searches for analyses that uses a data connection in the library with "Salesforce" in its title.

To search for items in the Files and data flyout:

  1. On the authoring bar, click Files and data .
  2. Click in the search field at the top of the flyout, and start typing the name of the content that you want to search for.
  3. As you type, all the files, folders, and other content that match your search string will be listed.
    Tip: To reset the flyout to the normal view, click the X button in the search field.