Analytics Studio

[まとめページに戻る](https://qiita.com/Keiji_otsubo/items/60afc2a8d211b6f7d89f)
[まとめA～M](https://qiita.com/Keiji_otsubo/items/f3ddedee6793bf1576f8)

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

+ [Unable to see Analytics Studio tab in App Launcher. Only Analytics tab is shown.](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007erLEQ)

:::note
Please check this article.

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



+ [Anyone Explain the 'CRM Analytics Studio' - Benifits, Limitation, Security Constarin, Query Limit in Dashboard, etc..](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007ifdrB)
+ [Tableau CRMのまとめ CRM Analytics](https://qiita.com/Keiji_otsubo/items/8e464969e91efce972da)


+ [「機能設定」＞「分析」内に「Analytics」がない](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007UvMyI)

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

+ [Einstein CRM Trailhead で作業しているときに、古くて使用できない「モデル」を削除する方法がわかりません。](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007T53bc)
+ [CRM Analytics-Enabled Developer Edition Orgが機能していない](https://qiita.com/Keiji_otsubo/items/ac31b1289cca32bb2166)

+ [Analytics Studio ダッシュボードの [編集] ボタンを非表示にするにはどうすればよいですか?](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007Cuxcm)

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

+ [List Widget on CRM Analytics Dashboard not allowing selection](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007OWLBg)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/3ed82fd9-85a7-c06c-c7b4-685264cb6ec0.png)

:::note
 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](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007MXm6k)

:::note
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.
:::

+ [ユーザーごとに異なるフィルターを使用してサブスクリプションを送信するレポート](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007O2CLVSA3)

:::note
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](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007NCCK3)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/11775de3-a3e1-bb92-a814-22759819fb91.png)

:::note
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　というメッセージを変える](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007Usf1w)

:::note
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 にアップロードする](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007Uv7a0)

:::note
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 への依存関係が表示されているため、オブジェクトを削除できません。](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007XIYBT)

:::note
Please check this article. 

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

+ [一部のチャートの動的読み込みを停止する](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007ZAAYp)

:::note
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](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007ZB9F9SAL)

:::note
マイナスは使えない・
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](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000JdTbh)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/58126e34-1878-2694-935c-c9a263b6ade2.png)

:::note
 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:

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

+ [Error: Cannot use date() function with time zones](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007eoYH7)

回避策を見つけたみたい


# 既知の問題？

+ [Recipe Transformation Sync Error - Error ID: 2000-21dda0da-0ePRO0000008I7p](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007StnZ2)


:::note alert

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](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007T4cad)

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

:::note
Please check this article.

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