まとめページに戻る
 まとめA～M

Tableau CRM は現在、CRM Analytics として知られています。新しい名前は、ネイティブ Salesforce プラットフォームでのイノベーションに対する私たちの使命とビジョンを反映しています。CRM Analytics は、プラットフォームの初心者でもプロでも、世界ナンバー 1 の CRM に基づいて構築されたインテリジェントなエクスペリエンスを提供し続けます。指を鳴らしてどこでも名前を更新できればいいのですが、置き換えるまでは、いくつかの場所で以前の名前が表示されることが予想されます。

Unable to see Analytics Studio tab in App Launcher. Only Analytics tab is shown.

Please check this article.

Analytics Studio does not appear in the list of apps
https://help.salesforce.com/s/articleView?id=000387453&type=1

ログインユーザーに「権限セットライセンス」と「権限セット」を付与することで「Analytics」が表示されました。

ボタン自体を非表示にすることはできません。アプリに対するユーザーのアクセス権を「閲覧者」に設定することのみが可能です。その場合、編集ボタンは表示されません。

List Widget on CRM Analytics Dashboard not allowing selection

It was something with my Playground. I created a new one for CRM Analytics and I'm not having the issue anymore.
:

Importing JSON on Analytics Studio

Create a new dashboard and sue ctrl+E or cmd+E to open the dashboard in JSON editor. Then past the JSON code and make sure to adapt the IDs of the datasets in the "datasets" section.

ユーザーごとに異なるフィルターを使用してサブスクリプションを送信するレポート

We can not subscribe reports which have dynamic run.

https://ideas.salesforce.com/s/idea/a0B8W00000GdbFAUAZ/make-subscribe-others-to-reports-dynamicrun-as-recipient

We can though create separate reports and set run report as each Recipient who will see the report. The Recipient must have permission to run reports and have access to the report.

動的に実行されるレポートをサブスクライブすることはできません。
ただし、個別のレポートを作成し、レポートを表示する各受信者としてレポートの実行を設定することもできます。受信者にはレポートを実行する権限とレポートへのアクセス権が必要です

Best practices to replace dataset

This sounds like a simple enough change but can get complicated depending on how you approach it.

First of all, Take a backup of your current dashboard json before you make the changes.

Second, If you directly go to the dashboard and do Cmd + E or Ctrl + E you will be able to access the dashboard json. I am assuming that this new dataset has all the required fields that are referenced in the existing dataset so the queries won't face any malfunctions when we replace it. If you approach this way, you'll need to make a few changes. The first change would be to the following part of the json,

"datasets": [
        {
            "id": "0FbDx00000xxxxxXXX",
            "label": "Dataset1",
            "name": "Dataset1",
            "url": "/services/data/v59.0/wave/datasets/0FbDx00000xxxxxXXX"
        }
    ]

Usually i scroll down to the bottom of the json and just replace the old Dataset ID and the Label and Name to the new ones.

The other thing to take care of is the fact that the references to the Dataset Name as well as the Dataset IDs are used in every query of your dashboard json. So the "steps":part of your json will have multiple references to the dataset. What i usually do is Ctrl + F on the window to open the Find and Replace functionality of the json, and Replace all the existing references of Dataset ID and Name to the new ones and Save it.

From your comments above, i can see that you havent done the second part of it because of which it is throwing errors now. You'll have to make sure that all the queries are referencing the new Dataset Name and ID.

No results found　というメッセージを変える

if you want to show "0" for your measure B instead of null, please use the coalesce() function, like coalesce(B,0). In case B gets null, this shows 0 as result.

Then change your formula to 'D-A' (assuming that the new column with the coalesce() function is named D) and hide B.

csv ファイルをプログラムで CRMA にアップロードする

Please check this article.

Create Datasets Programmatically from CSV Files Using the External Data API
https://help.salesforce.com/s/articleView?id=sf.bi_integrate_upload_csv_external_data_api.htm&type=5

組織内のオブジェクトを削除する必要があるのですが、datasetdata への依存関係が表示されているため、オブジェクトを削除できません。

Please check this article.

https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007T4QjnSAF

一部のチャートの動的読み込みを停止する

Yes - there's an option to set the "Faceting" behavior. If you don't want a chart (or othe widget) to get filtered by any actions, set the Faceting to "None". You can find this option in the properties panel on the right, select the query tab.

はい - 「ファセット」動作を設定するオプションがあります。グラフ (または他のウィジェット) がアクションによってフィルターされないようにするには、ファセットを「なし」に設定します。このオプションは右側のプロパティパネルにあり、クエリタブを選択します。

invalid arguments for power function -0.552971138104736, 0.3333333333333333

マイナスは使えない・
there is a limitation if your expression A/B is negative.

You can make a workaround for it: case when A/B < 0 then -(power(abs(A/B), 1/3) -1) else power(A/B, 1/3) -1 end. I used that workaround some time ago and it worked fine. You may also consider adding appropriate null or 0 handling.

Let me know if it works!

Page doesn't exist. Enter a valid URL and try again

I had one user with a Salesforce Platform license and custom user profile who was receiving this error as well. I found I had to update his profile with a specific custom tab setting that was not available on any CRM Analytics permission sets. (It doesn't appear to be an option on a standard permission set, either ... Weird.)

Here's the path I took to resolve this issue:

Go to the user's profile.
Go to Object Settings.
Find the tab with the Object Name of "Home" and the API Name of AnalyticsDataManager and click "Edit"
Change the profile's tab access to "Default On"

Error: Cannot use date() function with time zones

回避策を見つけたみたい

既知の問題？

Recipe Transformation Sync Error - Error ID: 2000-21dda0da-0ePRO0000008I7p

DataflowInstance 03CRO000001U0TR2A0 Failed. Hmm, that didn't work. Please try running the recipe again. Error ID: 2000-21dda0da-0ePRO0000008I7p. If the error occurs again, contact Salesforce Customer Support.

Data Processing Engine

DataflowInstance 03C3L0000007lIVUAY Failed. Something went wrong while executing the ConvertToEdgemart node: Visibility Descriptor column not found for Account object (02K3L000000ADr0UAG_03C3L0000007lIVUAY)

Please check this article.

https://issues.salesforce.com/issue/a028c00000gAzQdAAK/data-prep--error-something-went-wrong-while-executing-the-selectsharingrulesforaccountfrom-converttoedgemart-node